report based on drop down list (1 Viewer)

[shafh]

Hi everyone,
I have a report that is based on a Query. My query is based on two prompts from the user that appear everytime the query or report are run. These promts are:
>Date()-[Number of calender days back you want records for:]
and
[Please type in FirstName LastName of Analyst:]
My first prompt (the date) is fine the way it is, however for my second promt I would like to display a drop down list or something of the sort to avoid the need for Analysts to write in the precisely correct spelling of FirstName and LastName. 1 of 4 possible Analyst names should be selected by the person running the report/query.
Thanks,
Sam

 

[mark curtis]

Create a combo box and either populate it direct or via a table. in the query refrer to the combo box!

 

[shafh]

this worked!!!

>Date()-Forms!frmMyPrompt!txtDaysBack

and

Forms!frmMyPrompt!cboAnalyst