J
JLW
First Problem: I have a form for club members with a continuous subform
linked in a one to many relationship showing various clubs that members
belong to. I want to open the form using VBA so that it only shows people who
are members of a single club that I choose. I cannot seem to get the where
clause of the open form method to work when a subform is included. I have a
query that can return the required records but I cannot translate this into
opening the form with subform. Can anyone help please?
Second Problem: For the same form ad set up as above I have managed to
create a custom filter by form which concatenates choices that the user makes
into a where clause and opens the form to show the filtered recordset.
However, I am struggling to find out how to also include choices made in the
subform so that the form is opened to show a certain type of member (E.g.
Male) from the main form who is also a member of a certain club (E.g. Soccer)
from the subform. Any takers?
linked in a one to many relationship showing various clubs that members
belong to. I want to open the form using VBA so that it only shows people who
are members of a single club that I choose. I cannot seem to get the where
clause of the open form method to work when a subform is included. I have a
query that can return the required records but I cannot translate this into
opening the form with subform. Can anyone help please?
Second Problem: For the same form ad set up as above I have managed to
create a custom filter by form which concatenates choices that the user makes
into a where clause and opens the form to show the filtered recordset.
However, I am struggling to find out how to also include choices made in the
subform so that the form is opened to show a certain type of member (E.g.
Male) from the main form who is also a member of a certain club (E.g. Soccer)
from the subform. Any takers?