Actually, I'm not happy using a second form at all and would prefer to just run the query from form1 and return the results to form1.
Would you be satisfied with a list box on form1 showing the results of your query (assuming it doesn't return more than 1K records or so)? It will be readonly. There are a couple of ways to approach this.
1) OnClick runs a sub which builds a SQL string from the data in your form controls and uses it to set the list box rowsource.
2) OnClick requeries the listbox bound to a stored query which references the appropriate controls in your form.
Using this technique along with appropriate listbox properties is a quick way to focus on either a single record or a group.
I am very new to this (this is my first database!).
I have a table - MailingList - containing a list of names, addresses etc and a form - DataEntry - with this table as it source. I have a text box on the form in which the user will type a surname then click a button which I want to update the form to contain only records from the table with this surname.
At the moment, I can send the results to a second form by having a macro execute when the button is clicked - the macro performs the OpenForm action with the following WHERE condition