Search date VBA but subform

[Ruegen]

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

DoCmd.OpenForm "frmBookingEdit", , , "BookingDate BETWEEN #" & Me.txtFromDate & "# AND #" & Me.txtUntilDate & "#"

aside from getting the concatenation wrong (My first guess) is the form searchable if the date fields are in the subform?

[June7]

Data in the subform has no bearing on filtering the main form recordset. Child does not dictate parent.

[amrut]

One way around is to create and apply a filter to main form using the "linked master field" based on the dates in subform. In this case, records from main form matching the date criteria of subform will be displayed.

[June7]

Amrut, how do you propose that should happen? Yes, subform records will synchronize with the main form record but the date values are in the subform, not the main form, therefore the main form cannot be filtered on the dates.

[amrut]

Only the corresponding records of main form wherein the subform has atleast one record matching the date criteria will be displayed.
To create the filter, loop through the child table records between the required dates and create the filter using linked ChildField.