I have a form and subform linked and need to change the form and subform record source on open.
Everywhere I look I see that this should work. I placed the below code in both the form and subform open sub.
But when it opens I get an error that it cannot find the original source which I have renamed. How do I accomplish this? I have tried removing the original record source and leaving it blank but the form still does not update on open with the new table source.
Using Access 2007.
thank you.
Everywhere I look I see that this should work. I placed the below code in both the form and subform open sub.
Code:
Private Sub Form_Open(Cancel As Integer)
Me.RecordSource = Environ("USERNAME") + "_Buyback_template_t"
End Sub
Using Access 2007.
thank you.