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.