>Thank You Kenneth,
>
>I just can't figure out way this is so hard. There are so many places to put code in this software it blows my mind. If you could point me in the right direction it would help to no end. I've got the search form ready to go. My problem is I don't know where to put the code. I have a command button to start the search, where do I store the varabiles and how do I relate them to the text box's in my screen. Does it make it any more complacated by accessing more then one table. Please point me in the right direction.
>Thanks again
Shouldn't be that hard. :)
I always place the code into the command button. First you check if all textboxes have the valid values (they could be empty if it is allowed). Then you build your SQL string the way you are getting the right syntax. Then you execute your SQL and get the cursor. If the cursor is not empty, you run the report form.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison