start date and end date in form control subform results

[malaphasis]

I have two calendar pickers for a start and end date and want them to control the results of a subform to only display selected results.

thanks in advance

[June7]

What is the issue? What have you done to achieve the goal you stated? What is not working? Is the subform linked to dataset of main form?

Options:

1. dynamic parameterized query as form RecordSource (I never use dynamic parameterized queries)

2. VBA code to set form Filter and FilterOn properties

[NTC]

the sub form needs to be told when to requery; it doesn't auto update upon a change of date .... the AfterUpdate event of the date fields is one place - or have a command button just for that purpose....