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.
Foxpro is a sweet puppy
'cept it barks every now and then =)