Entering data to subform from a main form

[Lp12]

I have a search form with several criterias fields (Num,Dates etc..)
and by pushing the Search Btn, an hidden subform is apearing and i want the
Data that i retrieving to enter the subform. I get acknoledge abuot the
valitidy of the data (using the recordset method). and when i use the
command: DoCmd.OpenForm subformName, , strSQL , The subform is openning in a
new window with the right answers( record source is a query i built). but
again i want the subform in the search form to populated with the recordsets.

 

[Lance McGonigal]

Make your parent form an unbound form and have the query for the underlying
subform parameterized on the field in the parent. Clicking a submit button
will just requery the sub form.

Cheers.