After finally getting Dlookup to work I now realize there is a new problem; I am using Dlookup to match a users Windows log in name with the LogonID in my user table to populate a combo box with the users full name. This is working, however control list only contains my value. If the users logon name does not exist (or has changed) in my user table, the correct name is not populated in the control. How can I check for a match and display a msgbox if not found before populating the control?
SystemUser = GetUser() 'function that gets current Windows log on name
Me.cboRequestor = DLookup("FullName", "tblResources", "LogonID='" & SystemUser & "'") ' populates combo box