G
Guest
I am having a bit of trouble getting a Form to change the RecordSource.
I have 2 Forms -- one is a Login Form, and the other is an Admin form for
administering data.
The user clicks on their respective name in the Login form (no pwd
required), and it should change the RecordSource on the Admin form to the
matching users' data set.
I set the following code behind the OnClick event:
Form_TestForm.RecordSource = "Table2"
And it doesn't change the dataset. I also tried this code:
Forms!USA.RecordSource = "USA_Jim"
And that also doesn't work...
Anyone have any ideas? I thought it was simple, and found out it wasn't!
Thanks
I have 2 Forms -- one is a Login Form, and the other is an Admin form for
administering data.
The user clicks on their respective name in the Login form (no pwd
required), and it should change the RecordSource on the Admin form to the
matching users' data set.
I set the following code behind the OnClick event:
Form_TestForm.RecordSource = "Table2"
And it doesn't change the dataset. I also tried this code:
Forms!USA.RecordSource = "USA_Jim"
And that also doesn't work...
Anyone have any ideas? I thought it was simple, and found out it wasn't!
Thanks