Applying filters on the 3rd deep subform

  • Thread starter Thread starter SHIPP
  • Start date Start date
S

SHIPP

I am trying to apply a filter on the 3rd level of a
subform (a subform within a subform within a form).

The name of the form is..........frmMemoHdr
The name of the 1st subform is...frmMemoDetail
The name of the subform within
the subform is.................frmMemoDetailSub

I've tried this. It didn't work. Any ideas.

Forms!frmMemoHdr!frmMemoDetail!frmMemoDetailSub.Filter
= "[Item]=" & Chr(34) & strItemFilter & Chr(34)
 
I am trying to apply a filter on the 3rd level of a
subform (a subform within a subform within a form).

The name of the form is..........frmMemoHdr
The name of the 1st subform is...frmMemoDetail
The name of the subform within
the subform is.................frmMemoDetailSub

I've tried this. It didn't work. Any ideas.

Forms!frmMemoHdr!frmMemoDetail!frmMemoDetailSub.Filter
= "[Item]=" & Chr(34) & strItemFilter & Chr(34)
Click to expand...

You need to reference the subform control's "Form" property at each level, like
this:

Forms!frmMemoHdr.Subform1.Form.Subform2.Form.Filter = ...

You need to replace "Subform1" with the name of the subform *control* on the
main form (not the name of the subform, although the two may share the same
name) and "Subform2" with the name of the subform *control* on the first
subform.
 
Back
Top