K
Karen
I am creating a macro to validate a user name and password for a login form.
I created a unbound form which has a text box for username and a text box for
password. The user will enter each text box and click on command button
"go". For the command button, I want to create a macro for the "on click"
event. The macro will validate the username and password entered into the
form against the username and password in the Users table. I am having
difficulty with the expression. I tried
[Forms]![frmLogin]![UserName]=[tblUsers]![UserName] And
[Forms]![frmLogin]![Password]=[tblUsers]![Password], but I receive a message
that "The object doesn't contain the Automation object "tblUsers."
Any advise will be appreciated
I created a unbound form which has a text box for username and a text box for
password. The user will enter each text box and click on command button
"go". For the command button, I want to create a macro for the "on click"
event. The macro will validate the username and password entered into the
form against the username and password in the Users table. I am having
difficulty with the expression. I tried
[Forms]![frmLogin]![UserName]=[tblUsers]![UserName] And
[Forms]![frmLogin]![Password]=[tblUsers]![Password], but I receive a message
that "The object doesn't contain the Automation object "tblUsers."
Any advise will be appreciated