Get User Level on Login Form

[billgyrotech1]

Hi,

How can the field "User Level" on my Login form auto populate when the User Name is selected.

Hold down shift key when opening database.

Thanks,
Bill

[June7]

Since employee is a combobox, have its RowSource be a query that includes SecurityLevels table.
ColumnCount: 3
ColumnWidths: 1";0";0"

Then UserLevel locked textbox (not a combobox) can reference combobox column:
=[cboUserName].Column(2)

Also set its TabStop to No.

[billgyrotech1]

Thank you so much June7 that works perfectly!

You are amazing!