Applying a filter in a query

[king07]

Good Morning

I am attempting to apply a filter to a query i have setup. I only want the user to be able to search for specific words within two fields (technical and behvaioural) i have setup. I know i have to use a WHERE expression but am confused as how to exactly setup the expression... any idea's???

 

[Nick-in-Paris]

Filtering

I a know you can do this in a form, but not sure in a query, in the properties section for each field apart from the ones you want the information to come from, you can lock the data, so the only choices come from your two fields.

Hope this is of some use

 

[king07]

How would i go about locking the field-- i looked in the properties and am unable to find it

 

[Nick-in-Paris]

you're right

but i think the fundemental question is do you want people to look up fields in the query itself.
I've just tried locking data in a query and that doesn't wrk.
Try creating an auto form on your query: then go into design mode; right click each control in turn, go to the data tag, scroll to "locked" and change to yes.

In fact, the query is really the data input and storage area of the table, it's not really for open access, there are also areas within forms that allow you field by field to customise as to whether enter data, modify or erase. The tables and query side should be kept in te control of the dbase designer and the input come from the users via forms. Hope this helps