I am trying to build a password form for an Access Web Database. The password form asks for a username and password. The form, frmFaculty_Web, should then open to a specific record that matches the username and password. The username should be FirstName from tblFaculty, and the password should be LastName from tblFaculty. I have to use a macro on the password form to do this because of the limitations of a web database...it will not accept VBA. I cannot get the form to pass the parameters so that the frmFaculty_Web form will open. As you can see I haven't gotten past the first criteria (no idea how to do two). I know it has something to do with the Where clause in the macro. I have no idea how to do it. Can anyone help?? What am I doing wrong??
The password form has two text boxes: Text0 (username) and Text17 (password).
Here's a link to the actual database in my Dropbox if that helps:
https://www.dropbox.com/s/ztt1hswlqx...Database.accdb
If I can get this to work, the idea is to eventually populate the table and faculty form so that users can only see and edit their own record. Under no circumstances should they see anyone else's.