Requery Multiple Subforms

D

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
 
S

Sandra Daigle

me.sfrmMySub.requery

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

DavidW

Thanks!
Sandra Daigle said:
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
Click to expand...
Click to expand...
 
Top