Look Up Query

[ssworthi]

I have a report that is based on a query that currently asks for the area that they want for the report. I would like to instead make this a look up query and bring back results in the report for the selection(s) made. How would I do that? Thanks for any help; really, really appreciate it.

 

[Trevor G]

Create a form with a combobox that lists the area, set the report to use the query and set the criteria in the query to use the combo box. Add a button on the form to open the report.

 

[ssworthi]

Thank you so much Trevor; worked like a charm!

 

[ssworthi]

Now I need to create a form for updating information and would like to use the same type of criteria. How would I open the form based on the combo box criteria? Thanks so much for any help.

 

[Trevor G]

Its the same principal, create a form based on a query, then on the another form (perhaps the same as the report is running from when you select from the combo) you would have your combo and set the query criteria to look at the combo, then add a button to open the form after you have selected from the combo.