Pass DATA to query from FORM 1

[jestrada101]

How can I pass data from a form using a DROP DOWN that has data dynamically added from a table. I will select my data from teh drop down, then click on a button to send this to a pre-defined query.

Can someone guide me in the right direction?

Thanks!
JE

 

[PHV]

In your query you can reference the combo value as a parameter:
[Forms]![Name of your form]![Name of your combo]

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

 

[jestrada101]

Thanks... looks like I almost have it working. How would I have the query recognize a TAB on the page, since my form has multiple tabs.

thanks!
JE

 

[jestrada101]

Sorry... i had a typo!!!

Thanks for your help!

JE