I have the following code which it is in subform object event to check date overlapping:
If DCount("*", "Course Details", "InstructorID=" & Forms![Course Details]![Course Details Subform].Form.InstructorID & " AND Start<= #" & Me.End & "# AND End <=#" & Me.Start & "# and ID <>" & Me.id) > 0 Then
MsgBox "Overlapping course for this instructor"
Cancel = True
When the field "Start" updated, I get the following error msg:
Run-time error 3075 syntax error in date in query expression 'InstructorID=1 AND Start<=## AND End <=#11/20/2011# and ID<>5'
any help please?