Access2016, subfoem.requery did not work, help!

[Sinca]

Access2016, subform.requery did not work. subform based on query2 and query2 based on query1. I changed SQL text of query1 in VBA and want subform.requery to reflect the changes. The code goes as below:

dim db as database
dim qry as querydef
set db=currentdb
set qry=db.querydefs("query1")

qry.SQL=some string
me.subform1.form.requery

--------------------------------------
result:


1-sub form did not reflect changes.
2-I checked query1 and query2, they work properly.
3-if I close form and reopen it, it works! reflect all changes as I expected.

I can provide database file for details.
Please help. Thanks a lot!

[June7]

.form reference does not work because the form is not open as a form - it is an object held by a subform container, not a member of the open forms collection. Reference the subform container control, not the form in the container.

Recommend naming container different from the object it holds, like ctrDetails: Me.ctrDetails.Requery

Why are you changing query? This is modifying db design.

[Sinca]

Thank you for your help!
1-I tried renamed subform container as ctrDetails and use Me.ctrDetails.Requery, also did not work.
2-changing query is for passing combobox data in mainform to query parameters. So user can get the results he want based on his choice on combobox.
Now I am thinking after changing query1.SQL, still missing some action to do before ctrDetails.Requery so that passing the new SQL to subform.

[June7]

The requery method works for me, so yes, something else must be necessary.

If this query is the source for a form RecordSource then why don't you just apply filter criteria to form?

I have only ever once resorted to using QueryDefs to modify query and I was kicking and screaming the whole time. The query was not source for RecordSource, it was used to export data to Excel.