query from a drop combo box

[oggstar1]

I have created a drop combo box in a subform that generates a list of names from a table. The drop down menu has the following Row source.

SELECT [employees].[employeeID], [employees].[planner] FROM employees;

Now I need to use this table data for three new fields in a sub form. I would also like to query the field with my combo box, but when I display the query it shows the [employeeID], a number as opposed to a name from the [planner] field.

I really need to display the [planner] field, which would display the actually name as opposed to a number. Is this possible, as I have tried a number of things with no success?

 

[PHV]

Have a look at theColumn property of the ComboBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886