Filter main form on Subform

[Guest]

Hi,
I see that this question has been asked a couple of times, but the replies
were a little too difficult for me to interpret. Here's my question:
I have a form which I have activated the filter on form command which works
perfectly. In this form I have 2 seperate subforms which I would also like to
search on using the filter on form function. The subforms look like they can
work this way but it just isn't happening. Is it possible to search the
records in the main form based on filters in the subforms? The subforms get
their data from link tables. Thanks in advance,
-Ben

 

[Arvin Meyer [MVP]]

Hi,
I see that this question has been asked a couple of times, but the replies
were a little too difficult for me to interpret. Here's my question:
I have a form which I have activated the filter on form command which works
perfectly. In this form I have 2 seperate subforms which I would also like to
search on using the filter on form function. The subforms look like they can
work this way but it just isn't happening. Is it possible to search the
records in the main form based on filters in the subforms? The subforms get
their data from link tables. Thanks in advance,

A properly designed database will not have any records in the main form
which relate to anything but the key in the subform. Most, if not all, of
the time, the key in the subform would not even be visible, so there would
be no way to search anyway.

I can see where you might want to find all customers which bought a product
that was listed in the subform, but you should not show them in the main
form (1 side of the relationship) so you'd need a separate form for this
search.

Just what do you want to search in the main form, from a subform?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

I have 3 tables. One called 'Interfaces', one called 'data elements' and one
called 'source'. From one source can come many interfaces, and each
interfaces can have many data elements. The form I am conducting my search in
is the data elements form. In this form I have two subforms which display the
source and interface the element is linked to.
When I begin the filter on form function on data elements it seems that I
can also select filter criteria from my subforms. I thought I could use that
to search the related data elements. All of the subforms are linked to the
main form through the primary key. Ideally I would like to select an
interface (or source) and be able to look at the data elements linking to it.
I appreciate your help.