Change Query in Sub Form

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

Guest

Hello,
I have a main form with some combo boxes that I use to filter data in a sub
form. I have added a couple option boxes so that the user can choose which
data set to query in the sub form. I'm not sure how to code it in the on
click event of the option they select. Below is something I thought may have
worked but did not. Any help or suggestions would be greatly appreciated.

sub_form1.Recordset = "QueryName"
 
Set the RecordSource of the form in the subform control:
Me.[sub_form1].Form.RecordSource = "QueryName"

Or, if the query is already set up, you could just requery:
Me.[sub_form1].Form.Requery

If the ".Form" bit doesn't make sense, see:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html
 
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 Sub form opens before the main form in MS Access 0
Requerying combo box in sub sub form 6
Refresh data in sub forms when one sub form is edited 4
Refresh a combo box on a sub-form 2
Access Form Refresh 1
Update a date field in sub-form from dates fields on main form 1
Change Combo Box on Sub 9
docmd.gotorecord on sub sub form 1

Back
Top