Filter subform between dates on mainform

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hi All

I have a form with two txtboxes and a subform.
The txtboxes each represent a start_date and end_date
The subform has payments made.

I want to filter the subform to show payments made between the
start_date and the end_date.

The field on the subform that I want to filter is 'date_paid' as a date.

Any ideas greatly appreciated,

Jeff
 
Jeff said:
I have a form with two txtboxes and a subform.
The txtboxes each represent a start_date and end_date
The subform has payments made.

I want to filter the subform to show payments made between the
start_date and the end_date.

The field on the subform that I want to filter is 'date_paid' as a date.
Click to expand...


Several ways to deal with this. Probably easiest is to use
a query for the subform's record source. Set the datepaid
field's criteria to:
Between Forms!theform.start_date And Forms!theform.end_date
 
Back
Top