When i Add this Dlookup below to my code
"DOB = DLookup("[DOB] ", "staff1", " [DOB] = #" & forms!NewStaff!txtdob& "#") "
I get the errror message
the field DOB in the table and the venerable are both date type values
The full bit of code looks like this
sn = DLookup("[Sirname]", "staff1", " [Sirname] ='" & Forms!Newstaff!TxtSName & "'")
DOB = DLookup("[DOB] ", "staff1", " [DOB] = #" & Forms!Newstaff!TxtDOB & "#")
The first line works great, but the second line give the error message "invalid use of null"
I have check the table and the are no null values stored
AM using then to check the sir name of a user and the dob of a user are not in the table already.
I hope i have explained myself clearly enough.
"DOB = DLookup("[DOB] ", "staff1", " [DOB] = #" & forms!NewStaff!txtdob& "#") "
I get the errror message
the field DOB in the table and the venerable are both date type values
The full bit of code looks like this
sn = DLookup("[Sirname]", "staff1", " [Sirname] ='" & Forms!Newstaff!TxtSName & "'")
DOB = DLookup("[DOB] ", "staff1", " [DOB] = #" & Forms!Newstaff!TxtDOB & "#")
The first line works great, but the second line give the error message "invalid use of null"
I have check the table and the are no null values stored
AM using then to check the sir name of a user and the dob of a user are not in the table already.
I hope i have explained myself clearly enough.