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

  • Thread starter Thread starter deaconj999
  • Start date Start date
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
 
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
 
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
 
Back
Top