Creating a Lookup/List box on a parameter query

[Slip27]

I have a query to show info on a specific employee entered in the condition field (employee name) the condition is:

[Enter employee name:]

I would like to put a lookup type list on the condition when i start the quary (any form of dropdown list would work, just so i dont have to remember the spelling of some names, lol). I have tried the lookup tab in pref section of the quary field and this did not work. Could someone help me with this, Thanks.

 

[Rich]

Use a combo box which contains the employees, reference the combo in the criteria

 

[Slip27]

Thanks for the Help.

I think you do that in the field properties box for the field you are setting the criteria for in the query (EmployeeID) & I have done the following on the lookup tab:

Display Control Combo Box
Row Source Type Table/Query
Row Source tblEmployee
Bound Column 1
Column Count 2
Column Heads No
Column Width 10
List Rows 1
List Width 10
Limit to List YES

This does not seem to work as it does not produce a selection box on the criteria request when i run the query. I must be missing something but i cant seem to find it.

Thanks for you help.

 

[Slip27]

I got it to work

Thanks for your help, i got the lookup to work with the combo box - macro - query.

Its not clean, but it works well.

Thanks Again