filtering subforms

[Kathryn Fletcher]

I have created a form with 1 category in the main form (Essential Oil
Name). Within this form there are multiple pages using the tab format.
Within each of these pages there are multiple subforms (eg scent,
botanical name, note etc)which have a one to many relationship with
the main form.

When I try to filter a subform it returns what I want within the
subform. But I have to search through every entry in the main form
(essential oil name)for the answers.

How do I filter the subforms to only return pages from the main form
(essential oil name) that have a positive answer.

ie if I filter the note subform for *top* I only want to see the
essential oils that have top within the note subform. I also still
want to view all the other subforms that have not been filtered.

I have done alot of searching through help and the only way that I can
see that this can be done is to write a macro in the onapplyfilter in
the forms. Unfortenutley I am a wizard girl and have no idea where to
start to produce such a macro.

Your help would be greatly appreciated.

Thanks Kathryn

 

[Allen Browne]

See:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html

The article explains how to reassign the RecordSource of the main form to an
inner join statement so it contains only those records that have a match in
your subform.

You will not be able to achieve this with a macro - at least not without
much effort.

 

[Kathryn Fletcher]

Allen thanks for the response,

I have found a previous posting by someone that has written a macro
that seems to look great (not that I would know though) this is what
they wrote:

Thanks for the reply. I was dreading having to construct lengthy
code, and
up until the weekend I suspected that was what would be required.
Then my
brain finally ticked over and the resulting solution using Access
Query by
form popped into my head. It simply builds the querystring using the
filter
property of both the Main form and the SubForm, during the Applyfilter
event
of the subform. The code is as follows.

Public Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)

If Form_frmMain.doFilter = True Then
strSQL = "SELECT * FROM business_address INNER JOIN recipient ON
business_address.businessUID = recipient.businessID WHERE "
strFilterSub = Me.Filter
strFilterMain = Form_frmMain.Filter

If strFilterSub = "" Then
strSQL = strSQL & strFilterMain
ElseIf strFilterMain = "" Then
strSQL = strSQL & strFilterSub
Else
strSQL = strSQL & "(" & strFilterMain & " AND " & strFilterSub
& ")"
End If

Form_frmMain.RecordSource = strSQL
Form_frmMain.doFilter = False

End If

End Sub

doFitler is set to true if the "Search" button on the Main form is
clicked.
The code may be a little crude but works perfectly, and is a good
starting
point to develop onwards from.

Unfortunetly I can't figure out how to change it properly to fit my
database. I have changed what I think is correct in the strSQL by
creating a query but I can't get it to work past the first line
If Form_frmMain.doFilter = True Then, It comes up yellow in the coding
area.
I have tried changing the form name as I don't think mine is called
Form_frmMain (or if this is relivant to all main forms) but come to a
number of difficulties
1)In the coding area I find Form_Essential Oil name but it won't allow
me to do that as after the space after Essential it says that it is
looking for Then
2) In a drop down box in the coding area I have found it written as
Essential_oil_name this seems to work because there are no spaces.
3) Then I come to wonder what the .doFilter means, is that meant to be
a column in my table? As I look up help about doFilter and it comes up
with nothing. Lucky I read this again before I posted the messeage,
have they created a search button on the main form called doFilter? I
will try this but still could I get some help.
4) With the strSQL do I need to change all of the names from Essential
Oil name to Essential_oil_name or can I leave them in the brackets?

Hope someone can help me
The original coding comes from
http://groups.google.com.au/groups?...ccess&selm=3b834848%241%40clear.net.nz&rnum=4

Looking at the original messages may help you understand what I am
talking about as there problem is exactly what I am trying to do.

Thanks Kathryn Fletcher

 

[Allen Browne]

The code is definately the way to go, rather than a macro.

Re your specific questions:

1. Look at the title bar for the code window for your form, and use the name
Access uses. It probably has an underscore in place of the space, i.e.:
Form_Essential_Oil

2. Good.

3. "doFilter" must have been the name of some control on their form, such as
a check box or toggle button to indicate whether to do the filter or not. If
it looks like a button, make sure you use a toggle button, not a command
button: toggle buttons have a value and can be True; command buttons do not.

4. Within the SQL statement, use square brackets around the names that have
spaces. The actual field names or table names have not changed, so they
won't work with underscores. (The underscores are used in the event
procedures in VBA code.)

Access is pretty good at highlighting the problem in your code, and giving
you an error message so you know what to fix. Hopefully that will get you
going.

 

[Kathryn Fletcher]

Thanks Allen the comment about using the toggle button was a big help
as I was using a command button. Would you or anyone else to help with
Problem 2 (At the end of message) related to 3145 syntax error in
WHERE clause

I will start with explaining what I originally wanted to do for those
that have not been following as I believe what I have come up with
could be a great help to others. I had no idea how to even attempt
this and was baffled with all the different codes that people had.
Especially when there was mutiple things to do, so to those who think
they don't understand just try and follow the different things (eg
toggle buttons, command buttons) you will be suprised at how easy it
is to pick up.

I created a form with a number of sub forms inside Tab pages, each sub
form having a one to many relationship with the main form. I could
filter the subforms with no problem but I would have to go through all
the forms to find the results. So what I really wanted to was filter
the subforms and only return those results on the main form that where
positive for the filter in the subform (as well as all the other
subforms of course).

How did I achieve this
1) created a toggle button in the main form.
Set the default value in the properties to True.(Just type in True)
Changed the name to doFilter (this can be what ever you want)
Created an Event Procedure in the OnApplyFilter Property

Private Sub doFilter_Click()
On Error GoTo Err_Command85_Click


DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70

Exit_Command85_Click:
Exit Sub

Err_Command85_Click:
MsgBox Err.Description
Resume Exit_Command85_Click

End Sub

2)Found an event procedure posted in another message and played around
with it using some code from Allen Brown at
http://users.bigpond.net.au/abrowne1/ser-28.html
It is much easier to play around with the code in Visual Basics as it
highlights when you are doing something wrong.
Added the event procedure to OnApplyFilter Property of the sub form I
wanted to filter.
You will need to change names according to your database
Main things to note
a) Make sure your main form name has no spaces in it ie
Form_EssentialOilname
b) Create a query with the two forms go to the SQL string and copy and
past from the FROM into the strSQL in the code.

Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)

On Error GoTo Err_Form_ApplyFilter
' Purpose: Change the form's RecordSource to only products from this
supplier.
Dim sSQL As String
Dim bWasFilterOn As Boolean

' Save the FilterOn state. (It's lost during RecordSource change.)
bWasFilterOn = Me.FilterOn

If Form_EssentialOilname.doFilter = True Then
strSQL = "SELECT * FROM [Essential Oil name] RIGHT JOIN [Botanical
Name] ON [Essential Oil name].[Essential oil name] = [Botanical
Name].[Essential Oil] WHERE "
strFilterSub = Me.Filter
strFilterEssentialOilname = Form_EssentialOilname.Filter

If strFilterSub = "" Then
strSQL = strSQL & strFilterEssentialOilname
ElseIf strFilterEssentialOilname = "" Then
strSQL = strSQL & strFilterSub
Else
strSQL = strSQL & "(" & strFilterEssentialOilname & " AND " &
strFilterSub & ")"
End If

Form_EssentialOilname.RecordSource = strSQL
Form_EssentialOilname.doFilter = False

End If

' Apply the filter again, if it was on.
If bWasFilterOn And Not Me.FilterOn Then
Me.FilterOn = True
End If

Exit_Form_ApplyFilter:
Exit Sub

Err_Form_ApplyFilter:
MsgBox Err.Number & ": " & Err.Description, vbInformation,
Me.Module.Name & ".Form_ApplyFilter"

Resume Exit_Form_ApplyFilter
End Sub

This means you can filter the subform and only get back the main forms
that have that filter. Depending how you filter it works differently.
If you do a filter by form and you press the filter button (as you
can't press the toggle butteon in form filter) you will have to scroll
through all the forms, but if you press the toggle button after the
filter has been applied it will filter only to show the main forms
that have the filter in it.
You can also right click on the subform and filter this way, instead
of pressing enter press the toggle button

There is 2 problems with this

Problem 1 - solved
When you turn off the filter by pressing the filter button on the tool
bar all the informaton in the subform comes back. Good yes but you can
still only see the main forms that were filtered ie if you have 53
main forms and once you pressed the toggle to filter there is only 3
exactly what you wanted but even once you take the filter off there is
still only 3 main forms.
Problem the RecordSource of the main form is still set to the strSQL.
To fix this I created a Command Button with an event procedure in the
OnClick property.

Private Sub Command87_Click()
Form_EssentialOilname.RecordSource = "Essential Oil name"
End Sub

Even though it might seem long winded to do this it suits what I want
to do quite well.
Procedure going: filter by using toggle. Result, the subform only
showing the results I want (eg none of the other entries visible) and
only the main forms that have the positive results in the filtered
subform present. If you turn the filter off all the entries in the
subform come back, (which is useful for me) but still only the
original filtered main forms are present. To retrieve all of the main
forms you just need to press the command button.

Problem 2 - unsolved
I have copied and pasted the OnApplyFilter code into other subforms,
changing the strSQL using the query method.
The problem comes when I try and filter in the additional subforms.
Sometimes??? (Don't understand why only sometimes)a pop up comes up
with the error message 3145 Syntax error in WHERE Clause. If I press
okay the filter still works and you can carry on like normal. You can
filter as many times as you want in the same subform or in any of the
other subforms containing the code (again sometimes the error coming
up) but the code still works. I have no idea what the sytax error is
as I did not write the code I just adjusted it to suit my purposes.

Can some one please help me, I have nearly finished what I wanted to
achieve after many hours of work. I have learnt a fair bit but still
don't fully understand the stuff enough to know what is wrong with my
WHERE clause.

Thanks
PS I am new to using this messaging system and found the information
on here very useful and was very suprised to get a response to my
original questions so quickly. The reason I have written so much is to
try and help other dummies like myself can understand and it will
hopefully help them.

 

[Allen Browne]

Replies embedded.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"Kathryn Fletcher" <[email protected]> replied in message
[snip]

2)Found an event procedure posted in another message and played around
with it using some code from Allen Browne at
http://users.bigpond.net.au/abrowne1/ser-28.html

That site has actually moved to:
http://allenbrowne.com/ser-28.html
It is not supposed to be on the bigpond server any longer. (Looks like they
can't even get that right.)

Problem 2 - unsolved
I have copied and pasted the OnApplyFilter code into other subforms,
changing the strSQL using the query method.
The problem comes when I try and filter in the additional subforms.
Sometimes??? (Don't understand why only sometimes)a pop up comes up
with the error message 3145 Syntax error in WHERE Clause. If I press
okay the filter still works and you can carry on like normal. You can
filter as many times as you want in the same subform or in any of the
other subforms containing the code (again sometimes the error coming
up) but the code still works. I have no idea what the sytax error is
as I did not write the code I just adjusted it to suit my purposes.

Can some one please help me, I have nearly finished what I wanted to
achieve after many hours of work. I have learnt a fair bit but still
don't fully understand the stuff enough to know what is wrong with my
WHERE clause.

There are many possible valid reasons for this error, such as wrong or
missing delimiter, incorrect brackets, misunderstanding the field name or
parameter, misunderstanding which field is being referenced (e.g. where a
primary table and related table have fields with the same name.), or even
things like the wrong thing having focus.

When you receive the error message, the dialog has Debug and End buttons? If
so, choose Debug, and print the string you are trying to use as a filter.
Then try to create a query using that as the WHERE clause, and see if you
can identify what the problem is.

It is also possible that the message indicates some kind of corruption.

 

[Kathryn Fletcher]

Thanks for your reply Allen
This is another lengthy explanation hope you get through it all.
Debuging code, I do not know how to get the debugging to run unless I
try the filter and the error occurs. With the full code posted last
time with the bits from your web page I was unable to do this as the
pop up box comes up instead. So I went back to the original code:

Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)
'MsgBox (Form_EssentialOilname.doFilter.Value)
' MsgBox ("Record source: " & Form_EssentialOilname.RecordSource)
If Form_EssentialOilname.doFilter.Value = True Then
strSQL = "SELECT * FROM [Essential Oil name] RIGHT JOIN Scents ON
[Essential Oil name].[Essential oil name] = Scents.[Essential Oil]
WHERE "
strFilterSub = Me.Filter
strFilterEssentialOilname = Form_EssentialOilname.Filter
If (strFilterSub <> "" And strFilterEssentialOilname <> "") Then
strSQL = strSQL & " WHERE "
End If

If strFilterSub = "" Then
strSQL = strSQL & strFilterEssentialOilname
ElseIf strFilterEssentialOilname = "" Then
strSQL = strSQL & strFilterSub
Else
strSQL = strSQL & "(" & strFilterEssentialOilname & " AND " &
strFilterSub & ")"
End If
' MsgBox (strSQL)
Form_EssentialOilname.RecordSource = strSQL
Form_EssentialOilname.doFilter = False

End If
End Sub

Noting that this error only occurs when more than one sub form has
this code in it.

This code was put into the subform Scents and subform botanical name.
(I originally thought that the order I added the code in may be linked
to the problems but it doesn't matter if I put it in scents or
botanical first I still get the same problems)
- When I filter the Scents subform it works fine. ie subform and main
form are filtered, filter button on the tool bar is depressed, toggle
button is not depressed.

- When I filter the Botanical name subform it comes up with the error
(3145, syntax error in the WHERE clause)
If I try to debug I notice that the problem is not in the Botanical
name coding area but in the Scents coding area. Thus it looks as if it
is trying to go through this one first????
It highlights this bit yellow (4th line before the End Sub)
Form_EssentialOilname.RecordSource = strSQL
If I hold the curser over it a box comes up, usually both sides of the
= sign have the same thing. In this case they do not.

Form_EssentialOilname.RecordSource comes up with
Form_EssentialOilname.RecordSource = "Essential oil name"
and
strSQL comes up with
strSQL = "SELECT * FROM [Essential Oil name] RIGHT JOIN Scents ON
[Essential Oil name].[Essential oil name] = Scents.[Essential Oil]
WHERE "

I stop the debug and I go back into the form, the filter has been
applied to the subform but not the main form. Both the filter button
and the toggle button are depressed (1), 2) and 3) are tried from this
point ie when both the filter button and toggle button are depressed)
1) I click on the filter button on the tool bar to turn it off the
same error occurs. I go debug and press stop, and go back to the form,
the filter is applied to the main form but no longer to the subform
and both buttons are not depressed any more.
OR
2) If I press the arrows down the bottom of the main form to go to the
next form the filter applies to the main form without an error and the
toggle button is no longer depressed. If I click on the depressed
filter button on the tool bar the subform filter clears and the main
form is still filter (as I expect it to be).
3) If I press the toggle button, it is released. The filter button is
still depressed, if I press it, it is released and the filter in the
subform is unfiltered. None of this effects the main form.

More info. If I filter (toggle button) in the Scents subform, and with
out unfiltering (clicking on the depressed filter button on the tool
bar) I filter (toggle button) in the Botanical Name subform it works.

Scenario 2, with 3 subforms. Code added to Scents, Botanical Name and
Made from subforms.
-If I filter with toggle in Made from it works. ie subform and main
form are filtered, filter button on the tool bar is depressed, toggle
button is not depressed.

-If I filter in Scents it comes up with the error (3145) in the Made
from coding area
with this bit highlighted
Form_EssentialOilname.RecordSource = strSQL
when I put curser over it it shows that
Form_EssentialOilname.RecordSource = "Essential oil name"
strSQL = "SELECT * FROM [Essential Oil name] RIGHT JOIN [Made from] ON
[Essential Oil name].[Essential oil name] = [Made from].[essential
oil] WHERE "

I stop the debug and I go back into the form, the filter has been
applied to the subform but not the main form. Both the filter button
and the toggle button are depressed (1), 2) and 3) are tried from this
point ie when both the filter button and toggle button are depressed)

1) I click on the filter button on the tool bar to turn it off the
same error occurs. I go debug and press stop, and go back to the form,
the filter is now applied to the main form but no longer to the
subform. Both buttons are no longer depressed.
OR
2) If I press the arrows down the bottom of the main form to go to the
next form the error (3145) occurs this time in the Botanical Name
coding area
with this bit highlighted
Form_EssentialOilname.RecordSource = strSQL
when I put curser over it it shows that
Form_EssentialOilname.RecordSource = "Essential oil name"
strSQL = "SELECT * FROM [Essential Oil name] RIGHT JOIN [Botanical
Name] ON [Essential Oil name].[Essential oil name] = [Botanical
Name].[Essential Oil] WHERE "

If I stop debug and go back to the form the toggle button is no longer
depressed. And the filter is applied to both the subform and the main
form. If I click on the depressed filter button on the tool bar the
subform filter clears and the main form is still filter (as I expect
it to be).

3) If I press the toggle button, it is released. The filter button is
still depressed, if I press it, it is released and the filter in the
subform is unfiltered. None of this effects the main form.

- If I filter in the Botanical Name subform it comes up with the error
in the Made from coding area
with this bit highlighted
Form_EssentialOilname.RecordSource = strSQL
when I put curser over it it shows that
Form_EssentialOilname.RecordSource = "Essential oil name"
strSQL = "SELECT * FROM [Essential Oil name] RIGHT JOIN [Made from] ON
[Essential Oil name].[Essential oil name] = [Made from].[essential
oil] WHERE "

If I stop debug and go back to the form the filter is applied to the
subform but not the main form.Both the filter button and the toggle
button are depressed (1), 2) and 3) are tried from this point ie when
both the filter button and toggle button are depressed)
1) If I click on the filter button on the tool bar to turn it off the
same error occurs in the Made from coding area . If I click debug and
then stop another error occurs this time in the Scents coding area
(same error just the strSQL = the scents strSQL) If I go back to the
form, the filter is now applied to the main form but no longer to the
subform. Both buttons are no longer depressed.
OR
2) If I press the arrows down the bottom of the main form to go to the
next form the filter applies to the main form without an error and the
toggle button is no longer depressed. If I click on the depressed
filter button on the tool bar the subform filter clears and the main
form is still filtered (as I expect it to be).
OR
3) If I press the toggle button, it is released. The filter button is
still depressed, if I press it, it is released and the filter in the
subform is unfiltered. None of this effects the main form.

It doesn't seem to matter which code is added first but there does
seem to be an order to it as the same errors occur in each subform no
matter which one is entered in first, maybe has to do with which
subform was entered first into the form - I will try this next but I
have spent hours compiling this so I am off to bed.

Hope you got through it all, I tried to make it flow as easy as I
could but there does seem to be a trend.

Kathryn

Replies embedded.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"Kathryn Fletcher" <[email protected]> replied in message
[snip]

2)Found an event procedure posted in another message and played around
with it using some code from Allen Browne at
http://users.bigpond.net.au/abrowne1/ser-28.html

That site has actually moved to:
http://allenbrowne.com/ser-28.html
It is not supposed to be on the bigpond server any longer. (Looks like they
can't even get that right.)

Problem 2 - unsolved
I have copied and pasted the OnApplyFilter code into other subforms,
changing the strSQL using the query method.
The problem comes when I try and filter in the additional subforms.
Sometimes??? (Don't understand why only sometimes)a pop up comes up
with the error message 3145 Syntax error in WHERE Clause. If I press
okay the filter still works and you can carry on like normal. You can
filter as many times as you want in the same subform or in any of the
other subforms containing the code (again sometimes the error coming
up) but the code still works. I have no idea what the sytax error is
as I did not write the code I just adjusted it to suit my purposes.

Can some one please help me, I have nearly finished what I wanted to
achieve after many hours of work. I have learnt a fair bit but still
don't fully understand the stuff enough to know what is wrong with my
WHERE clause.

There are many possible valid reasons for this error, such as wrong or
missing delimiter, incorrect brackets, misunderstanding the field name or
parameter, misunderstanding which field is being referenced (e.g. where a
primary table and related table have fields with the same name.), or even
things like the wrong thing having focus.

When you receive the error message, the dialog has Debug and End buttons? If
so, choose Debug, and print the string you are trying to use as a filter.
Then try to create a query using that as the WHERE clause, and see if you
can identify what the problem is.

It is also possible that the message indicates some kind of corruption.

 

[Allen Browne]

Hi Kathryn

It's a bit late at night here for me to wade through your 1500 word essay,
but you seem to be applying filters to the main form and subform at the same
time. Not sure if you have read:
Incorrect filtering of forms and reports
at:
http://allenbrowne.com/bug-02.html
This new article outlines how Access does not correctly maintain a filter
for the main form and subform properly. It should not cause the WHERE error
you referred to, but anything is possible once Access is confused.

 

[Kathryn Fletcher]

I know it was a long message I did warn you, but didn't relise it was
1500 words, wish I could have written essays for uni that quickly.

I read the web site that you suggested and those were the exact things
happening to me, I thought about the fact that changing the
recordsource effected the onfilter. I remebered in the code that I
made mixing the information from your web site and the other code I
found had something about turning the filter back on. I looked at the
code more closely to find out what was causing the pop up box to
appear and took it out of the code by using the ' in front of it.
The full code is bellow but I the bit I took out is
Err_Form_ApplyFilter:
' MsgBox Err.Number & ": " & Err.Description, vbInformation,
Me.Module.Name & ".Form_ApplyFilter"

Private Sub Form_ApplyFilter(Cancel As Integer, ApplyType As Integer)

On Error GoTo Err_Form_ApplyFilter
' Purpose: Change the form's RecordSource to only products from this
supplier.
Dim sSQL As String
Dim bWasFilterOn As Boolean

' Save the FilterOn state. (It's lost during RecordSource change.)
bWasFilterOn = Me.FilterOn

If Form_EssentialOilname.doFilter = True Then
strSQL = "SELECT * FROM [Essential Oil name] RIGHT JOIN [Botanical
Name] ON [Essential Oil name].[Essential oil name] = [Botanical
Name].[Essential Oil] WHERE "
strFilterSub = Me.Filter
strFilterEssentialOilname = Form_EssentialOilname.Filter

If strFilterSub = "" Then
strSQL = strSQL & strFilterEssentialOilname
ElseIf strFilterEssentialOilname = "" Then
strSQL = strSQL & strFilterSub
Else
strSQL = strSQL & "(" & strFilterEssentialOilname & " AND " &
strFilterSub & ")"
End If

Form_EssentialOilname.RecordSource = strSQL
Form_EssentialOilname.doFilter = False

End If

' Apply the filter again, if it was on.
If bWasFilterOn And Not Me.FilterOn Then
Me.FilterOn = True
End If

Exit_Form_ApplyFilter:
Exit Sub

Err_Form_ApplyFilter:
' MsgBox Err.Number & ": " & Err.Description, vbInformation,
Me.Module.Name & ".Form_ApplyFilter"

Resume Exit_Form_ApplyFilter
End Sub

And for some really bizarre reason the filtering seems to be working
fine!!!! ie no errors are coming up.
Does this actually mean the error is not occuring or without the error
message in the code it is just bypassing my need to turn the pop up
box off. Because as I said previously if I pressed okay to the pop up
box the filter worked.

There are a few inconsitancies with the filtering which represent the
problems on the web page you suggested
Filtering by right clicking is subform
ie If I filter in the subform botanical name (1 of 4) using the toggle
the filter works. subform scents now (1 of 1) and main form changed
from (1 of 53) to (1 of 3). If I then try to filter in subform
scents(1 of 6) without turning off the either the subform filter (by
clicking the depressed filter botton on the tool bar) or the main form
filter (the command button that resets the recordsource of the main
form) the filter is still applied to the subform botanical name (1 of
1) and is applied to the subform scents (1 of 1) but the main subform
is now (1 of 22) - this is the amount you get when scents is filter
by itself. Therefore there are some blank places in the botanical name
subform and you have to click through all 22 forms to find where both
the filters apply to both subforms.

Hence if you try and filter twice only the second filter is applied to
both main form and subform, and the first filter only to the subform.

Filtering by form (add filter criteria, press filter, once back in
form press toggle to filter main form)
If multiple filters are added, all are filtered before the toggle is
pressed. After the toggle is pressed the main is filtered for only one
subform and the other subforms are no longer filtered. I have 3
subforms in a row it is always the one on the left. This comes back to
my thought about the order I entered the subforms into the form
(although it is the opposite to what seemed to happen when the errors
were coming up ie the form on the right was always the one that the
filter worked on with no problems, and the other subforms errors
always occured in it first. Atleast when a single filter was applied
by clicking the right button on the subform).

If you have any suggestions about fixing the multiple filtering
problem it would be greatly appreciated. And or answer the question,
are the errors still occuring.

Thanks
Kathryn

PS made this one a bit shorter