Help please using a combo box with a query instead of the usual wildcards etc.....

D

deaconj999

Hi,

I have nearly finished my database and I would like to add a query
that uses a combo box to get the results, not the usual paramater
style input. I suppose it would need a form and a query and a combo
box, but where to start !!!!!!!!

Any kind soul out there that can give me an example of where to
start..........?

Many Thanks

Joe
 
J

Jeff Boyce

Joe

The generic approach you'd use is:
* create a new form, add a combo box that is set to return the value your
query would need
* create your query ... in the criterion "cell", put a reference to the
form's combo box's value:
Forms!YourFormName!cboYourComboBoxName
* for this to work, the form MUST be open
* add a command button to the form -- and have that button run the query

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

deaconj999

Joe

The generic approach you'd use is:
* create a new form, add a combo box that is set to return the value your
query would need
* create your query ... in the criterion "cell", put a reference to the
form's combo box's value:
Forms!YourFormName!cboYourComboBoxName
* for this to work, the form MUST be open
* add a command button to the form -- and have that button run the query

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP










- Show quoted text -
Click to expand...

Thanks for that, got it working now
 
Top