Set value of combobox from variable

[PrimaryKey]

Hello all.

I have a combobox that allows users to select users from the sys_Users table. The combobox had a record source that combines the UserID of the user with their First and Last names from the Employees table.

When users login, their UserID is stored to a TempVars variable, and I just want to set the intial value of that combo box to the TempVars!UserID, but things like: Me.UserID.Value = TempVars!UserID don't work. Does anyone know how to do this?

[ranman256]

you can get the userID from their login:

cboBox = Environ("Username")

[PrimaryKey]

you can get the userID from their login:

cboBox = Environ("Username")

The only thing is that I don't want to use their Windows username, as some of our computers are shared with universal user accounts. So I want to populate the combo box from the users table in the database. I'll try cbobox = TempVars!UserID though

[PrimaryKey]

you can get the userID from their login:

cboBox = Environ("Username")

That worked! Thank you! I guess I was trying to over-complicate the process thinking I had to include .Value or .Selected . . .

Thank youi!