Requery Subform from another form.

[calvinle]

Hi,

I have looked kver many site for solution and many tries but still does not work so I am wonderin if anyone can help:

I have a mainform with subform filtered on onload event.
I am using docmd open form dialog to open another form, then when the changes is made to the record, then when closing the dialog form, the requery wont work on the subform of the main form which means it doesnt remove that record off the subform. If i click on the "Refresh" ribbon, then the refresh will work and the record is removed from the subform.

Why?

 

[spikepl]

Not stories but code: show how you requery

 

[calvinle]

Oh nevermind. I figure it out. The changes were made to the second form, but not to the first form. Since the second form subform is linked to the mainform subform, i have update the record on the mainform subform, then everrything works now.thanks