Setting the RowSource of a subform in Access 200 programmatically [** RESOLVED **]

[M Owen]

Hi all.

The day has come ... I have an Access 200 DB with a form within a form (subform) THis subform is designed to be bound to a template table. I need to reassign the rowsource of this subform to a table I create on the fly ... I don't see any exposed method for doing this in the "subform" control. Any ideas?

P. S. - I tried calling the form name explicitly with no success ...

Thanks!

- Mike

[M Owen]

UPDATE:

Found it...

Example:

Me.TimesheetDetail.Form.RecordSource = ArchiveTbl