Requery a series of queries from a form

[leicklda]

I have a form with a subform. When I change data on the form, I need the subform to update. The problem is that the subform is based on a query, which based on another query, which is based on another query, which is then based on the data I have just changed in the main form.

I have tried requerying the subform object, but that doesn't work. Do I need to requery each series of queries? So I would need to requery query1,2,&3?

And how do I do that?

Any help would be greatly appreciated.

 

[hermanlaksko]

At some time you must end up with a recordset on the subform no matter how many queryes you use. You should be able to se the recordset via me.recordset on the subform.

Change the recordset to me.recordset="select ...... Where ID=" & forms!YrForm!Date