Help with Query

[chasmith17]

I have created an asset inventory db and I want to search the description field in my form. I cannot get the query to work right. Can anyone tell me how to make this work? Thanks,

 

[PHV]

Can anyone tell me how to make this work?
How to make WHAT work ?

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

 

[chasmith17]

I have a form that is tied back to an Asset table.. I want to search for records in a certain field (The field name is Asset Description)in my form. So when I go to the field name asset description (in my form) I can type in the first few letters and it will come up with what I am looking for and fill in the rest of the asset info in the other fields. I have done this before in a parts db but can't remember how. I thought I made a query, maybe not. Sorry for the confusion I don't have all of the terminology down yet.