setting filter on a subform from a calendar control

[Paul Doree]

Hi,

I've got a calendar control on the main form, and I want a subform to be
filtered to the date selected on the calendar control, but can't get the
syntax right.

The subform needs to display all dates at first, until the date is selected
in the control, then once that is done just display the rows for the
selected date (the date field in the subform is called DateWorked).

Any help appreciated.

Paul.

 

[Douglas J. Steele]

Create a query to use as the RecordSource for the subform. The Where clause
should be something like:

WHERE (([MyDateField] = Forms![NameOfMainForm]![NameOfCalendarControl])
OR (Forms![NameOfMainForm]![NameOfCalendarControl] IS NULL))