05 – Switchboard Forms – Calling Functions

In this post, we will be showing you how to call a function from a Swtichboard.

Being able to call code from a Switchboard is very useful as it gives us the flexibility to determine how we open our forms and reports. In the video, we show you how to use a filter to open up the Supplier's form. This enables us to only view records that are relevant to what we are looking for and is a much more efficient way of working.

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.


In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!

3 Comments

  • Steve Winkler says:

    I’ve studied the code for this and pretty much understand what you’re doing. I want to do something similar but I want my filter to open a report that’s populated with a query. Is this possible?

    • Steve Winkler says:

      I’m trying to figure out if this is possible to do without VBA? I’m playing around with criteria in the query but am having trouble handling situations where a combo box might have a null value.

    • Robert Austin says:

      It is definitely possible.