Drop down box for Query criteria selection

[Guest]

I am at a loss for how to create a drop down box in a query that has select
criteria []. This would be helpful in not having to type user names all the
time. I have tried properties - Combo box, Table/query then the place the
criteria comes form - No luck. Help please. I use Access 97 at work (that is
what i am working in) but have XP at home.

 

[Douglas J. Steele]

Create a form with the appropriate combobox on it, and have your query refer
to the combobox.

In Access 97, select "parameter queries" in the help file, then choose
"Create a parameter query that gets criteria from a custom dialog box" from
the list of possible topics (it's the 2nd one).



--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



"Dropdown box for Access97 Query criteria" <Dropdown box for Access97 Query
(e-mail address removed)> wrote in message
news:[email protected]...