One date selection to rule them all

[guinness]

Hi folks

I have a menu form that has buttons linking to several pivot table forms. All of the pivot table forms have the filter 'W/C Date by Month'. This is fantastic and provides a flexible and useful report however, on a weekly basis, users are likely to access each pivot table and want it filtered for that week.

Could I have one date filter on my menu form that would filter all the subsequent forms to the same date if a date were selected or leave the forms as they are if no date was selected?

Any help is much appreciated on this one.

 

[PaulO]

Yes, don't see why not ...

On your menu form create a formatted (date) text box, that is blank that can be entered up if required.

Create the same on each of your pivot forms

Get your pivot queries set date criteria of [menu form]![date] or [pivotform]![date]

So long as one of the date fields is left blank you should be OK