not sure of the code

[peterbowles]

two questions

I want to open a form2 IF

Form1=
txtbox1 = Password FROM table People
AND

txtbox2 = ID FROM table People

if no record found
Msgbox "no record"

Also

If a user enters text into a field how do you check if the same text has been entered in the same field in a different record


Thanks in advance for any help

 

[boblarson]

You could open a recordset clone and loop through it.