Filter Problems on Main form & Subform

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have a an Access 2000 database with a Main Form and
several Subforms. My Main Form has a filter which works
fine alone. However when I turn on the Filter in the
Subform the Main Form Filter no longer works. Any idea
why not? I also noticed when I set Me.FilterOn = True in
the On Open Event of the Subform it also turns on the
Filter for the Main Form. Why is that? Here's the key
properties of the Main form and Subform:

Property Main Form Subform
Default View Single Form Single Form
Views Allowed Form Form
Filter [Assembly Plant ID]=28 [Paint System]='Phosphate'
Allow Filters Yes Yes
Allow Edits Yes Yes
Allow Deletions No No
Allow Additions No No
Data Entry No No
Recordset Type Dynaset Dynaset
Pop Up No No
Modal Yes No
Cycle Current Record Current Record
On Open Event Me.FilterOn = True Me.FilterOn = True
Me.SetFocus
DoCmd.Maximize

Any ideas would be appreciated!

Sincerely,

Jeff
 
Back
Top