Error on query for list box

[irunergoiam]

I've got a list box on a form that is based on a query. The query CurrentPositionValidate1 works just like it's supposed to (when the form is open and the EmployeeID field has a value).

However, when I plug the query into the list box I get the following error: "Syntax error (missing operator) in query expression 'CurrentPositionValidate1.'."

The only thing that was at all out of the ordinary is that when I built the query I had to convert a field in a linked table that stores EmployeeID as number to text. I did this using the Cstr() function. I have to convert this field as the EmployeeID field I'm linking to from another table/query is a text field.

Any ideas out there would be greatly appreciated and rewarded with much good Karma!

Thanks...

 

[Trevor G]

Does your list box include the id field? you can hide the field from being displayed but it would be useful to have this and then set the query to look at the listbox values you select.