Query on a Unbound form with Null Values

[Kenny]

Hi, I have a query that I use with an "Unbound Form". There is approximately 10 fields on this form. I want user to have the ability to search using this unbound form. Some of the field’s don’t need to be searched all the time. How can I write the query so that when a user searches some of the fields and leaves some blank it, will still get the records that they need. In the query design menu I have this code in one of the fields: [forms]![frm Query transparts]![part] what if the user wants to leave this field blank when he is doing a search but he puts data in the others. I dont know VBA..Sorry. Kenny

[recyan]

Till some one comes along, just check if below gives some guidelines :

https://www.accessforums.net/showthr...3-Search-Query

Thanks

[ssanfu]

I think this is what you are looking for:

Queries: Use a parameter to return all records if Null

http://access.mvps.org/access/queries/qry0001.htm