I have created a form that must look up a users username and password from a Members Table and tell me whether they exist or not.



i have the following code but i get error number 2001 when i click the button

If-DCount("*","qryCheckUserAndPWord")=0

im new to access and would appreciate some help

thanks

SOLVED NEVERMIND