Ed,
Thanks for responding, I will look into the SQL. I want to let you know the user only uses one of the text boxs on the search form the one they pick, thru my code in the valid box I set the other parameters with no value.

example:
User want to search on name:
lcSname = alltrim(text1.value)
lcAccount = ' '
lcSaddress = ' '
etc,

Then when I run the query the only thing it looking for is lcSname the other parameters has no value.

If you see a problem with that please let know. wright now it works but I don't have that many records in the table.