Setting RecordSource

  • Thread starter Thread starter Jimart
  • Start date Start date
J

Jimart

Hi

I Have A Main Form this form has a Subform The SourceObject for the
Subform is another subform.
I have mastered changing the SourceObject, so that I can have
different Subforms appearing when I need them BUT what I need to be
able to do is to change the RecordSource of the SourceObject Subform
from the code behind the Main Form, so I can reuse the SourceObject
Subforms

Thanks for any help
 
Me.Subform.Form.RecordSource = "Your SQL or tablename or queryname string
here"

where Subform is the name of the control that holds the subform.
 
Back
Top