Form data does not read into query.

[sdimaggio]

I have a query running off of a form.

In the criteria section of my query I have the following code:

[forms]![frm_PlantProfiles].[employees]

I am trying to do a query of employees "greater than" 2000.

When I place 2000 in the form field the query displays all the plants with 2000 employees. However, when I type " >2000 " in the form's text box, I get a no data in the query and a message that says it's too complex.

When I type " >2000 " directly in the criteria section of the query it works. Why then does'nt it work when it grabs the criteria off of the form.

What am I doing wrong?

Any help would be greatly appreciated.

 

[PHV]

In the criteria section of your query:
>[Forms]![frm_PlantProfiles]![employees]


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