Subform Refresher

[scott04]

Hi everyone,
I know this isnt the first time this has been asked but i have had trouble
trying suggestions off other posts but here is the problem. I have a form
named frm_audit and a subform named frm_Lifesubform. On the form I have a
button that loads a schedule into the subform on click however the data does
not get loaded until I close the form and go back into the form. The subform
is run off a query called adsQuery. Is the probelm that my subform is based
on a query and is that why it doesnt refresh?

 

[ruralguy via AccessMonster.com]

What is your button doing to "load the schedule into the subform"? Done
properly, the schedule should appear immediately.

 

[scott04]

Actually put a requery in the subform on click event and form requery in the
afterupdate and it now works

 

[ruralguy via AccessMonster.com]

It sounds like you got it sorted. Thanks for posting back.

Actually put a requery in the subform on click event and form requery in the
afterupdate and it now works

What is your button doing to "load the schedule into the subform"? Done
properly, the schedule should appear immediately.

[quoted text clipped - 7 lines]