Changing record source of sub form on report.

[TommyDuke]

Does anyone know how to change the record source on a sub form on a report. I just need to know what event fires when the control (sub form) is loaded on the report. I,ve put breaks in the Current, Open, and Load of the sub form and the report never breaks. It just loads.

Thanks for all the help,
Tommy

 

[ump38]

Not sure about the event order or if it really matters. I generally do this in the Open Event:

Me!subform_name.RecordSource = << insert appropriate source>>
Me!subform_name.Requery

This effectively controls the record source for the specified subform ("subform_name" would obviously be the actual name given to the subform.)

Hope this helps!

 

[TommyDuke]

Apparently you can't change the record source of a sub form on a report. I referenced the form like you said and still I get the ERROR message "Object doesn't support this object or method. If you know anything else please reply, otherwise thanks for the help.
Tommy