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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Main form/Subform Navigation 0
sub form & sub-subform drill down question 3
Populate subform field on Afterupdate of main form field 6
use recordset as source for form 16
recordset for a subform 14
Subforms 1
GoToRecord for a subform 4
Dynamically changing a subform's recordset using txt box 1

Back
Top