I have created a scheduling database for my department at work where people put in requests. Unfourtunately someone is messing with other peoples schedules so each individual record needs to be password protected
To do this I have created a seperate field in the table containing vital information for a password. I then created an unbound text box in the search form I created to allow you to type in a password. From there it links into each persons schedule requests. My problem is I am trying to use macro conditions to search and tell if the passwords match. If the passwords don't match I want a text box to appear with information saying the passwords don't match and then have it close the schedule form. My hang up is I don't know how to type in " not equal" as the way to make it search
So here is the conditional. It works if it is equal how do i write it if it is not equal
[Forms]![Employee find]![Password]=[Forms]![Employee all]![Password]
Sorry for the newb questions
Chris BEnitez
To do this I have created a seperate field in the table containing vital information for a password. I then created an unbound text box in the search form I created to allow you to type in a password. From there it links into each persons schedule requests. My problem is I am trying to use macro conditions to search and tell if the passwords match. If the passwords don't match I want a text box to appear with information saying the passwords don't match and then have it close the schedule form. My hang up is I don't know how to type in " not equal" as the way to make it search
So here is the conditional. It works if it is equal how do i write it if it is not equal
[Forms]![Employee find]![Password]=[Forms]![Employee all]![Password]
Sorry for the newb questions
Chris BEnitez
