Parameter Drop Down List

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

I currently have a query with a parameter in it [FULL NAME]. Instead of the
query prompting me with just an input box, I want the query to provide me a
drop down list of all of the available FULL NAME possibilities.

Can someone please help me :)

Tiffany
 
A query can be used to drive a Form.
And fields on a Form can be used to narrow down the query results.

So, on your form I would add a Combobox that is based on a query of all the
FULL NAMEs.
When you select a value from the combobox, you will fire the AfterUpdate
event.
In that event you can Requery your form.
The Form is based on a Different query (Employee table, for example)
so when you pick a Name, you see the record for that employee.

The query criteria for all Employees uses:
Forms![EmpForm]![ComboBoxName]
 
Back
Top