Entering data to subform from a main form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top