Dymanic query from combo box

[01jeffro]

I am a relativly new user who wants a query requirement to be what the user chooses in a combo box. Any help?
Thanks, Jeffro

 

[SIG357]

The most straightforward way to do it is to dynamically create your SQL query in code after the user makes a selection from the combo box. I'll show you how in a minute

 

[BLutgen]

In the query criteria field type in:

[Forms]![FormName]![Comboboxname]

This will set the criteria of the query based on whatever is chosen in the combo box.

Brad

 

[01jeffro]

Thanks a bunch! That is suprisingly simple.
Cheers, Jeffro