CuriousGeo
Registered User.
- Local time
- Today, 00:23
- Joined
- Oct 15, 2012
- Messages
- 59
Hello, I have a combobox on a form that is a list of usernames. It works in it's present state. However, what I would like to do is to change the list of names if the combobox is Null (no user has been selected). In that case, I would like the list to select the current user that has the database open. It would get the user ID from a hidden text box I have on the form. That way, the only name that would show in the combobox is the current user.
Otherwise, any previously selected username would still appear for other records where a name is already present in the combobox.
Current source of the combobox (cboInspectBy) is:
SELECT tblUsers.UniqueID_Users, tblUsers.fldUserName
FROM tblUsers
ORDER BY tblUsers.fldUserName;
The hidden field that contains the current user's UniqueID is called txtUserID
How would I write the criteria for this combobox?
Otherwise, any previously selected username would still appear for other records where a name is already present in the combobox.
Current source of the combobox (cboInspectBy) is:
SELECT tblUsers.UniqueID_Users, tblUsers.fldUserName
FROM tblUsers
ORDER BY tblUsers.fldUserName;
The hidden field that contains the current user's UniqueID is called txtUserID
How would I write the criteria for this combobox?