Unanswered: checking to see if Environ$("username") is in a list of users
I have splash form that loads first when my access db starts up. I'd like to add logic to check if the user is in my list of valid users.
I've tried to use the DoCmd.RunSQL command but I've learned from reading some older posts here that you can't use it to select statements - its only for active commands.
So.. the other idea I had was to try to bind a drop down list to the form and loop through it for an entry that matches Environ$("username"). But that doesn't seem like good design either because if the list of usernames grows, i don't want to loop through everything each time.
I didn't see any cbmoUsernames.Exists() method that would let me just try a matching string.
Any suggestions would be appreciated. I apologize in advance if I'm missing something obvious- still a ms access forms newbie.