Filter SUBFORM On Open

  • Thread starter Thread starter SusanV
  • Start date Start date
S

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
 
Nevermind, another blond moment. In case anyone's interested:

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

;-D
 
Back
Top