Nested sub form

Joy83

Member
Local time
Yesterday, 17:38
Joined
Jan 9, 2020
Messages
116
Good Day,
I have an issue in referencing a filter for a nested sub form.
It is taking me longer than it should.. I am sure I can find the answer quickly here.

1- I have a subform named “ChildTest” in the main form name “FrmMain”
2- that subform is linked to another form named “FrmReqMain”
3- in that form there is a subform named “FrmReq” linked to another form named “FrmReq”

I want to make a filter in “FrmReq” based on a combo box in “FrmReqMain”

please note that I am accessing all from the main form “FrmMain”


Can you please help
 
Just too slow. 😏
I was going to add exactly the same link which covers almost every scenario ... unless you are using the built in navigation forms.
 
Thanks ...
I tried that link before.. it didn’t work for me.
How to add the filter? Is ig considered a control or what..
Do you have a code example file ?
 
Thanks ...
I tried that link before.. it didn’t work for me.
How to add the filter? Is ig considered a control or what..
Do you have a code example file ?
Hi. Can you post a sample copy of your db with test data? Referring to subform controls requires using the precise name of the control. Sometimes, it may not be the same name as the Form it contains.
 
I agree that seeing a copy of your database would be best approach.
However, you could review this video by Steve Bishop helps and/or its follow on video to see if the info helps resolve your issue.
Didn't work doesn't give readers any detail to work with.
 
Rather than using filters, add criteria to the RecordSource queries of the subforms and when the criteria changes, requery the subform.

Select ...
From ...
Where SomeField = Forms! FrmReqMain!cboSomeField;

In the AfterUpdate event of cboSomeField:
Me. FrmReq.Requery
 
It worked
Many thanks to all of you
i knew this would save time!
I changed the filter to requery thanks Pat
 

Users who are viewing this thread

Back
Top Bottom