Switchboard Event

[lpgagirl]

My database has a switchboard with 6 buttons to choose from. One of these buttons will list all records associated to a company name. Currently, when the button is clicked an "Enter Parameter Value" window comes up to have the user enter the name of the company to search for. Once the company is entered the DB opens a subform with all records associated. I would like to have a selection box appear instead of an enter parameter value window, where the user can simply select from the drop down list which company he wants to view. How can I do this?

Thanking you in advance,



Jeannie

http://thefloyds.50megs.com/index.html

 

[PHV]

One way is to have a form with a combo and a button.
The combo list the companies.
The button launch the form with the selected criteria.
Note: the form's underlaying query shouldn't be parametized.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lpgagirl]

I am using a "HandleButtonClick(3)" in the on click event of the switchboard button; where 3 is defined as: Const CmdOpenFormBrowse.

In this case how can I have a drop down list instead of the paremeter value window?

Thanks again,

Jeannie

http://thefloyds.50megs.com/index.html

 

[PHV]

Sorry, I've never played with switchboard.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886