Accessing subform record set on form instance

[newfrontiers]

Hello. I'm spinning my wheels again on subforms. Ugh!

I am trying to set the recordset for a subform on an instance of a form.

I am using the context Me.subformname.Form.RecordSet but I keep getting an error that the object cannot be found. Is this because I am calling an instance of the form?

Is there a solution?

Thanks in advance.

 

[PHV]

If the code is really in the mainform:
Me![name of the CONTROL hosting the subform].Form.RecordSet

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

How are ya newfrontiers . . .

Is it your intent to refer to [blue]Recordset[/blue] or [blue]RecordSource?[/blue]

From the mainform ... reference would be:

[blue]   [[purple][B][I]subFormName[/I][/B][/purple]].Form.[purple][B][I]PropertyName[/I][/B][/purple][/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]