Parameter Drop Down List

[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

 

[Joe Fallon]

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]

 

[HSalim]

No Can do.
You'll have to use a form to achieve what you want

HS