I am running a query off a form. T

[circles]

I am running a query off a form. The query counts certain items. I am wanting to enter a number if the field off the form, so the query will only show the count greater than a certain number. Currently I use the criteria of >[form feild. This works off the parameters, but not the form. I am wanting to know what needs to be done to get the query to work off the form. Thanks

 

[KenG]

I don't really understand your question, if the criteria in the query already works when the parameter refers to >[formfield] then what form are you talking about?

 

[tlbroadbent]

To utilize the value of a form field in a search you must use the following syntax in the query designer criteria.

> [forms]![formname]![fieldname]

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin