I wasn't too sure where to post this, Queries or in Forms.
Anyway, I have a database, with the main form (frmMain) to enter data, I have copied this form to turn into the search form(frmSearch), I have done the straight copy paste, to get the search form looking and feeling the same as the main form, I have created a button to do the search which works but, everytime I open the search form it lists all the records, what I want it to do is to be blank, so I can enter the search criteria as needed. What am I missing, if I take out the Record source, which is pointing to the same query as the main form, all the fields come up with "#Name?".
I hope someone can help me
Anyway, I have a database, with the main form (frmMain) to enter data, I have copied this form to turn into the search form(frmSearch), I have done the straight copy paste, to get the search form looking and feeling the same as the main form, I have created a button to do the search which works but, everytime I open the search form it lists all the records, what I want it to do is to be blank, so I can enter the search criteria as needed. What am I missing, if I take out the Record source, which is pointing to the same query as the main form, all the fields come up with "#Name?".
I hope someone can help me
