yes the table and form is called directors, however
the variable is taken from the form contact_details.
the form directors is only used if the condition is true or we wish to add new data
Novice
Windows 7 64bit 
Access 2010 32bit
yes the table and form is called directors, however
the variable is taken from the form contact_details.
the form directors is only used if the condition is true or we wish to add new data
Administrator
Windows 7 64bit Access 2010 32bit
See if:
intChk = DCount("*", "directors") > 0
...still throws an error.
Novice
Windows 7 64bit Access 2010 32bit
the error is gone,
but its not checking to see if true or falso
Administrator
Windows 7 64bit Access 2010 32bit
That tells you Access does not like something in the criteria:
"[contact] = '" & Me.[contact name] & "'"
...it implies the two are not the same datatype.
Check multiple data
What is the best way to check for missing data?
Posting Permissions
Reply With Quote