WHERE Date = #" & Format(Forms!BookingForm!Date,"mm/dd/yyyy") & "#....
Also Date is a reserved word in Access, if that is a field name in your db then you should change it
What is [Text] try
Between ([Forms]![fAG_Articles]![txtStartDate]) _
And ([Forms]![fAG_Articles]![txtEndDate])))if you are trying to define the field as text then you have to define the parameters, which should be Date/Time
Private Sub Collections_subform_Enter()
If IsNull(Me.CustomerID) Then
Beep
MsgBox "There are no Customer details entered yet, please correct this"
txtSurname.SetFocus
End If
End Sub
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.