Hi, I urgently need help please.
I have the following:
Form - UserLogin with these unbound text boxes on it namely: txtOperator, txtUsername, txtPassword
Table - Operators with the following fields
Operator, Username, Password
My scenario is:
If I type something in txtOperator, then it must return the Username of that Operator from the table into the txtUsername unbound field.
Also when I type the password in the unbound txtPassword field, it must look up in the table if the txtPassword matches with Password from the table.
Further I can add in what I want.
Will someone PLEASE help me to find a solution for this. I have tried lookups and functions but no luck.
Your help is much appreciated - Thanks
Ryno