Drop down box for Query criteria selection

  • Thread starter Dropdown box for Access97 Query criteria
  • Start date
D

Dropdown box for Access97 Query criteria

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.
 
D

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
[email protected]> wrote in message
news:[email protected]...
 
Top