On Click - Change Record Source

[Mike C]

I would like to change the record source of my subform
when I check a box on my form. I know how to do it with a
list box but I can't figure out how to do it with a form.
Any ideas or suggestions would be greatly appreciated.

Here is list box example: Me.lstFinal.RowSource
= "qry_Final"

 

[Steve Conway]

Hi Mike,

Me.sfrmControlName.Form.RecordSource = "SomeqryName"

where sfrmControlName is the name of the subForm control on your main form.

HTH
Steve C

 

[Neil]

Mike,

Me.SubFormControlName.Form.RecordSource = "qry_Final"

You may need to requery the subform after you change the SourceObject to
update the changes.

HTH,

Neil.