Just wondering if anyone could please help me with this:
I have a Login form that the user logs into when the db starts. The query OpenRepFromLogin selects the User's ID (RepID) based on the username entered in the Login form. The query works - but how do I get the RepID into a text box, called OpenRepID, on the form? I tried the code below but it didn't work.
DoCmd.OpenQuery (OpenRepFromLogin)
Me.OpenRepID.Value = OpenRepFromLogin!RepID
Thanks - I really need the help with this one.
I have a Login form that the user logs into when the db starts. The query OpenRepFromLogin selects the User's ID (RepID) based on the username entered in the Login form. The query works - but how do I get the RepID into a text box, called OpenRepID, on the form? I tried the code below but it didn't work.
DoCmd.OpenQuery (OpenRepFromLogin)
Me.OpenRepID.Value = OpenRepFromLogin!RepID
Thanks - I really need the help with this one.