I have some forms that have date fields that I need to search between on the subform.
The main form gets opened by a button with
aside from getting the concatenation wrong (My first guess) is the form searchable if the date fields are in the subform?Code:DoCmd.OpenForm "frmBookingEdit", , , "BookingDate BETWEEN #" & Me.txtFromDate & "# AND #" & Me.txtUntilDate & "#"