Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm

[chip01051959]

Perhaps this will help to explain what I am trying to do using a macro button on a main form to filter data in my subform.


VBA Macro process for first button:
In my subform I have a [DueDate] field.

I need to be able to filter between a date range within the [CompletionDate] field in my subform.

The user should click on the button on my main form.

A pop-up window will appear requesting the user to enter the begining [CompletionDate] value desired and the last [CompletionDate] value desired.

The results will filter all records between these two dates in the subform.


VBA Macro process for second button:
In my subform I have a [DueDate] field and want to find processes that are late.


I need to filter records where the [DueDate] < Date() AND [CompletionDate] = NULL

AND

I also need to filter records where the [CompletionDate] > [DueDate] in the same VBA macro function.

Note: If your suggested VBA code changes my SouceObject/Master/Child fields, then I also need code to change them back to their original settings for other macro buttons to function.

Any assistance would be greatly appreciated!!