Referring to a form field in the where clause

[EHS]

I'm trying to construct an sql statement that will filter the contents of a field (from a query), based upon the contents of another field on the form. The statement works if I put a string in the where clause instead of the filter field name, but I don't know how to specify the field name in the where clause. Can anyone help?
Thanks

 

[vbaInet]

Is the control bound or unbound?

 

[EHS]

it's bound

 

[MStef]

In the Query criteria put;

[Forms]![FormName]![FieldName]

 

[vbaInet]

If it's bound you shouldn't be filtering the form based on that bound control.

 

[EHS]

Thanks vbaInet and MStef. [Forms]![FormName]![FieldName] in the query worked!