Filter Problems on Main form & Subform

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update subform with combobox change on main form 1
FORM-SUBFORM DATA ENTRY MODE PROBLEM!! 4
Filter subform using combobox on main form 1
Subform Filter Problem 1
Can't edit subform - main form should not be edited. 2
Additions Denied 4
Form Opens Blank/Appears as if Filter Applied 4
Unfiltering a subform has problems 1

Top