How to requery record source in subquery 1

[101287]

I have a form with a subform. I would like to requery the subform by changing the roecord source in the subquery. Can someone let me know how to do that in vba. Need to do that to refresh the suform query information.

Your guidance and assistance will be appreciated.

Luis

 

[dhookom]

I'm not sure I understand what exactly you are attempting to change but you might want to check out faq701-7433.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

Assuming it is a stored query changing from "query1" to "query2".
Me.YourSubFormControlName.Form.recordsource = "query2"

Or you build a query dynamically

dim strSql as string
strSql = .....
Me.YourSubFormControlName.Form.recordsource = strSql

 

[101287]

MajP your suggestion/recommendation work great. Thank you.