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?
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?