Enable Tab Control Using Simple Password Check

[rhettblaine]

Good morning all!

I'm trying to work out a feature where the user has to do a sort of "login" where they enter their user ID in a tab folder to enable access to the 2nd tab. I have a table with a roster that has my team's name and next to it a column with their User ID.

The intent is that the user selects their name from a combo box and then enter their User ID in a text box. After clicking 'Submit', the Submit button will do a check to make sure that the User ID matches the user name selected.

I'm thinking that this could be done with a query, but I'm stuck. Any ideas on where to start?

Thanks!!