L
Laura via AccessMonster.com
Hello
I have the following setup:
Mainform=frmcontactenter
Subform=subformactions
The two are linked together by ID on the mainform (recordsource
tbldemographics) and CenterID on the subform (recordsource is tblactions).
All of the subforms within the mainform are on different pages of a tab
control. When I move over to my Actions page (subform) the records from the
ID selected on the main form are there. I have linked them through the Child
Fields and Master Fields.
This seems to work great and gives me those records related, however I want
to add a command button to the subform which will allow me to filter out
those "actions" in which are completed. I have a field names 'status' in the
tblactions which has the option for open or closed. I cannot seem to get this
option to work for me. Microsoft states that a filter on a subform does not
filter the mainform, however it does for me? I tried to create an apply
filter query, which works for me when only the subform is open independently,
however when used with the main form I get an error saying it is looking for
the fields on the subform which have the specific criteria set. Of course it
is! It is looking on the main sheet which works independently of my subform.
I could sure use some help and advice on where I should start.
Thank you,
Laura
I have the following setup:
Mainform=frmcontactenter
Subform=subformactions
The two are linked together by ID on the mainform (recordsource
tbldemographics) and CenterID on the subform (recordsource is tblactions).
All of the subforms within the mainform are on different pages of a tab
control. When I move over to my Actions page (subform) the records from the
ID selected on the main form are there. I have linked them through the Child
Fields and Master Fields.
This seems to work great and gives me those records related, however I want
to add a command button to the subform which will allow me to filter out
those "actions" in which are completed. I have a field names 'status' in the
tblactions which has the option for open or closed. I cannot seem to get this
option to work for me. Microsoft states that a filter on a subform does not
filter the mainform, however it does for me? I tried to create an apply
filter query, which works for me when only the subform is open independently,
however when used with the main form I get an error saying it is looking for
the fields on the subform which have the specific criteria set. Of course it
is! It is looking on the main sheet which works independently of my subform.
I could sure use some help and advice on where I should start.
Thank you,
Laura