Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Open View-only form by Switchboard (2003)

    I have a requirement to open a form via the Switchboard but it must be acFormReadOnly. I have written the code as a new function (as that was what the dialog expected) for the Switchboard.

    My question is how to use the Switchboard manager that I want that code executed.

    I have tried putting the function name in the Function Name box but to no avail. What point am I missing?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open View-only form by Switchboard (2003)

    Forgive me - having not used the Switchboard previously, I did not realise that although I could not work out how to tell it to run a Function, I could simply create a macro and call that.

    Yes, it was simple, really, but it does help to spend a bit of time exploring features before reaching for the keyboard! Thanks.

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Open View-only form by Switchboard (2003)

    You can also use a VBA routine to open a form and other things, such as hiding the Switchboard form. You simply specify the name of the procedure - functions don't work well in that regard as they expect to return a value.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •