Need to know how to use a drop down list to populate a search field

[jomoan via AccessMonster.com]

I have a report that before it runs a search criteria field pops up and the
user then needs to type in the required search criteria. Once the search
field is populated the report then runs based on the search criteria [i.e.
date ranges]. I want to have a drop down list open up when the search field
opens so the user can populate the search field by clicking on an item from
the drop down list that is open on the screen. Is that do-able without
knowing any code?

 

[Duane Hookom]

IMO, never use parameter prompts in queries. Use controls on forms for all
user interaction http://www.tek-tips.com/faqs.cfm?fid=6763.

 

[Chuck]

I have a report that before it runs a search criteria field pops up and the
user then needs to type in the required search criteria. Once the search
field is populated the report then runs based on the search criteria [i.e.
date ranges]. I want to have a drop down list open up when the search field
opens so the user can populate the search field by clicking on an item from
the drop down list that is open on the screen. Is that do-able without
knowing any code?

'clicking on an item' implies that you are selecting only a single item.
Start with a form. Put a ComboBox in the form. Have it get its data from a
query, presumably from a field in a table. Place a command button on the form
to open the report and a separate command button to close the form.

It appears you report gets its data from a query. If so, in the query set the
criteria of the field that the report is searching to:
[forms]![name of form]![name of combo box]

Chuck
--