S
Seba via AccessMonster.com
Hello,
I have a table with the following fields ManagerLast Name, First Name,
Password. In one the forms I created, it has many fields from different
tables including the ManagerLast Name field and another field call
ManagerApproved, however, not a password field. I would like to create a VBA
command so that I have an inputbox where a user will type in his/her password
and the form will filter to show only the Manager's Last Name and any
ManagerApproved fields where the field equals to "NO". How can I go about
doing this? Do I add a text box to the form first with the password field
and then create teh VBA? Any help would be great. Thanks in advance. I
tried doing this in a macro and works great, but when I try to call this in a
Switchboard, access just hangs and this is why I think the VBA command might
help.
I have a table with the following fields ManagerLast Name, First Name,
Password. In one the forms I created, it has many fields from different
tables including the ManagerLast Name field and another field call
ManagerApproved, however, not a password field. I would like to create a VBA
command so that I have an inputbox where a user will type in his/her password
and the form will filter to show only the Manager's Last Name and any
ManagerApproved fields where the field equals to "NO". How can I go about
doing this? Do I add a text box to the form first with the password field
and then create teh VBA? Any help would be great. Thanks in advance. I
tried doing this in a macro and works great, but when I try to call this in a
Switchboard, access just hangs and this is why I think the VBA command might
help.