Filter SUBFORM On Open

[SusanV]

Hi all,

I have a form with general data on it, then a subform with related records.
I'm looking for a way to open the main form with the subform filtered. For
example, my main form has data about Jack, such as name and address. The
subform has a list of tasks Jack needs to do, and a due date. How can I use
a modal form (already created, with days of the week) to open the main form
and apply a filter to the subform to only show tasks due on Monday?

TIA,

SusanV

 

[SusanV]

Nevermind, another blond moment. In case anyone's interested:

Private Sub Form_Load()
Me.FilterOn = True
Me.Filter = "Due = '" & strDue & "'"
End Sub

;-D