G
Guest
Hi all,
I dont know if my conception is right (may be somebody can advise better),
but what i want is:
while the form is for "single" input, i want in the right part to appear the
"continuous" lists of records similar to the current one filtered by this or
that criteria.
So what i did - i made one subform based on the same source as the form and
was trying to apply different filters on it.
Then i thought that the "Tab" view would look nice - so i made 4 tabs with
same subform on each (each "child" is named differently) and managed to link
child-master fields for the 2 of them so it really shows what i want.
the other 2 tabs - i got problem. Tried to set filter "on click" for tab's
heading, but somehow insuccessful...
1st tab needs to filter subform by 2 criteria:
Me.MainForm.DocType1 = Me.SubForm1.DocType1
AND
Me.MainForm.Project1 = Me.SubForm1.Project1
(Main form and sub-form have similar names for fields)
and 2nd tab needs to show all records where
Me.SubForm2.FollowUp1=true
Please can anybody help me with the code and advise where to place it?
Thank you.
Lana
I dont know if my conception is right (may be somebody can advise better),
but what i want is:
while the form is for "single" input, i want in the right part to appear the
"continuous" lists of records similar to the current one filtered by this or
that criteria.
So what i did - i made one subform based on the same source as the form and
was trying to apply different filters on it.
Then i thought that the "Tab" view would look nice - so i made 4 tabs with
same subform on each (each "child" is named differently) and managed to link
child-master fields for the 2 of them so it really shows what i want.
the other 2 tabs - i got problem. Tried to set filter "on click" for tab's
heading, but somehow insuccessful...
1st tab needs to filter subform by 2 criteria:
Me.MainForm.DocType1 = Me.SubForm1.DocType1
AND
Me.MainForm.Project1 = Me.SubForm1.Project1
(Main form and sub-form have similar names for fields)
and 2nd tab needs to show all records where
Me.SubForm2.FollowUp1=true
Please can anybody help me with the code and advise where to place it?
Thank you.
Lana