Open form based on table authentication - How?

[SteveL]

I have a table with user names in it. Also, have a form for a user to enter a "login" name. If the name they enter in the form exists in the user name table, then I want a second particular form to open. How do I do this?

--Steve

 

[charityg]

I've attached a sample. The way it works is this. For each user, store the form name for the form you would like to open for each user.

In the Login button click, first open a recordset to select that particular user's record. If found, pass the Form name to the open form command.

Let me know if you have any questions.

Try entering charitya or guest as the user name.

 

[Cathyw]

Open form based on tables....

Hi. I hope you can help me. I have 22 different tables that have a form per table. I have created a search form for the user to type a TAG_NUMBER (field in each table). I would like the database to search for the tag in the 22 tables and open the form associated with that table. IE: If the tag comes from tblCode6 then I need frmCode6 to open. Got any ideas?

Thanks,
Cathy