Requery Multiple Subforms

[DavidW]

How do you go about refreshing other subforms on the same form?

I can get the first subform to refresh, but I can't get the second one to
show new data without closing and reopening the form.

If you need more information just let me know

Thanks
David

 

[Sandra Daigle]

me.sfrmMySub.requery

Replace 'sfrmMySub' with the name of the subform control - repeat for each
subform on the mainform.

 

[DavidW]

Thanks!

me.sfrmMySub.requery

Replace 'sfrmMySub' with the name of the subform control - repeat for each
subform on the mainform.


--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

How do you go about refreshing other subforms on the same form?

I can get the first subform to refresh, but I can't get the second one to
show new data without closing and reopening the form.

If you need more information just let me know

Thanks
David