Filter on subforms not working

L

Lyle

I have a tabbed form. On the second tab I have 3
subforms. Subform1 displays records from table
tbl_Locations. Subform2 displays records from table
tbl_Departments. Subform3 displays record from table
tbl_Titles. Each of these subforms has a filter. When I
open the main form, only the filter on the subform with a
tab index of 0 works. The other two do not. It doesn't
matter which subform is set to tab index 0, only that one
will work. I can open each subform independantly and
they each work. Each subform has Me.FilterOn = True in
the Private Sub Form_Load() code.
Can any one help??
 

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

DLookup in Continuous form 0
Synchronizing subforms 0
Form takes 2 seconds before subforms start to load 4
Subform 1
subform within subform On Main for Child master link question 2
First Subform record gets modified when closing form 3
Subform1 disappears when tab to subform2 0
Filter on Subform Not Displaying as Expected 1

Top