I have a database that currently uses a function to find the windows userlogin that they use.

I have that working fine however I am trying to set up an if function for when a button is clickedit to search for the userlogin within a table, and if it exist than it opens a different form than if not.

I know that the rest of my code works as I have used:

If fOSUserID = "lyona1" Then

it works, but want for it to search the column instead of having to add every user individually as these users may often change.