SQL subform record source

[Cobra17]

I'm trying to get a subform (FrmSub) to show data based on a table name that is passed by a variable 'x', in this case the table name is 'frmBuyouts', so I want to look in 'tblBuyouts' = tbl and filtered by 'EstID'.

I've tried recordsource, objectsource... any help would be appreciated.

Please Login or Register  to view this content.

[Cobra17]

figured it out....

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.