Drop Down Selection In Query

  • Thread starter Thread starter Michael Healan
  • Start date Start date
M

Michael Healan

Greetings:

I would like to know if anyone out there can point me in
the right direction. I have a table I would like to query
based on position in our organization. There are many. I
called the field position. When i run a query against the
table, i would like a drop down menu of all the available
postions, and would scroll down to the one i want and the
query would return the information accordingly.

Thanks,

MH
 
Michael said:
Greetings:

I would like to know if anyone out there can point me in
the right direction. I have a table I would like to query
based on position in our organization. There are many. I
called the field position. When i run a query against the
table, i would like a drop down menu of all the available
postions, and would scroll down to the one i want and the
query would return the information accordingly.

Thanks,

MH
Click to expand...

You can use an unbound combobox (or listbox) on a form. Its rowsource can be

SELECT DISTINCT position FROM yourtable ORDER BY position

(the order by is not necessary but quite convenient to the user). Then,
you can create a query on the table, with in the criteria row for
position this expression:
forms!yourform!yourcombobox
(or, more aptly, myCombobox since I invented it ;-) ) substitute as
appropriate
 
Back
Top