Query result for Default value in form

[1972Chevelle]

I have a user table that I use in a Login Form. Once the user has logged in they have access to various forms. I have a query that returns the current user logged in. I would like to populate the default value in the combo box. I have been able to populate the default value with the form value from [forms]![frmlogin]![cboUser] but that only returns the ID from the table and not the field I want which is the username. I can run a query on the user table and filter with the same [forms]![frmlogin]![cboUser] and I can return the logged in user but then I am trying to populate this into the default value of the combo box.

The databases is to track downtime on my equipment. Sometimes the the logged in user is not the user that is entering the data so they need to be able to select the correct user if they are not the logged in user at that moment in time.

Anyone have any ideas on how I can do this?

Gary

 

[GinaWhipp]

Hmm, not sure but I think you are looking for...

[Forms]![frmlogin]![cboUser].Column(1)

The above is assuming the UserName is in the 3 column of the Combo Box.

 

[1972Chevelle]

Worked great! I like simple answers too. It will be easy to remember in the future. Thank you very much!

 

[GinaWhipp]

You're very welcome...