Query all Records

[ptrifile]

I have a simple query that queries all orders in a database. I would like to be able to query by part # to pull up orders by specific part #, which i have succesfully done by placing [Part #] in the criteria of the query, however if a user wants to skip that by simply hitting enter without entering a PART # I would like all the records to show.....How can I accomplish this?

Thanks for any help!

Paul

 

[PHV]

=[Forms]![main form]![Part #] Or [Forms]![main form]![Part #] Is Null

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