ComboBox on Switchboard 1

[derekstewart]

I have several switchboards tied together and each has multiple buttons that trigger queries. Each of these queries requires user input in the facility column [Enter Facility Name]. I would like to create a combo box on the main switchboard that allows the user to select the facility. Then I can just reference that combo box in the queries [Forms]![search]![facility] and not have to request user input. When I try to add the combo box to the switchboard it shows all the facility names which I keyed in, but it won't let me select one. If I create a new form it works just fine, is there something about the switchboard. I can recreate the switchboards manually by creating individual forms but didn't want to reinvent the wheel. Any thoughts? Thanks. D

 

[missinglinq]

The default setting for Allow Edits in a Switchboard form is No. You cannot make selections from comboboxes when this setting is in place. Go into Design View for your S/B form and change this setting to Yes. That should do it.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[derekstewart]

Thanks. I appreciate the help. D

 

[missinglinq]

That's why we're here!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!