Sub Form RecordSource 1

[LarryDeLaruelle]

Is it possible to change a subform's recordsource from the main form? Based on user choices, I want to change the query behind the sub form or, alternatively, use and sql string in record source. I've tried:

frmSubForm.recordsource =
or
me.formSubForm.recordsource =

both produce an error that says the property is not recognized.

Thanks in advance

Larry De Laruelle

 

[Remou]

This is perfectly possible. You must remember that a subform consist of a subform control and the form contained. It is the recordsource of the contained form that you wish to change so:

Me.[Name Os Subform Control].Form.RecordSource = "SELECT * FROM table"

http://lessthandot.com

 

[LarryDeLaruelle]

Remou:

Thanks for the reply and the code.

Works like a champ. I guess I was on the right track, just did not have the syntax correct.

Thanks again.

Larry De Laruelle