Subform is not refreshing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form which displays appointments and a subform that displays details
about each appointment. When I scroll through the appointments, the subform
follows nicely.
The issue arises when I query the form and no appointments come up, in other
words, the main form is blank. In this case, the subform displays the details
about the last appointment that was displayed before the form went blank.
This is terribly confusing for my user since he assumes that his query worked
since the bottom subform is displaying data, when in fact this is simply left
over from the last appointment that was displayed.
I cannot figure out how to get the subform to go blank as well.
The subform is located in the main forms footer and linked through the
Master and Child properties.
Any help would be appreciated.
Thank you.
Paul
 
Hi Paul,

try this:

on the main form Current event:

me.subform_controlname.requery


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Thank you for looking at this Crystal!

I tried your suggestion, but unfortunately no luck. I placed a breakpoint on
that line of code, and that event doesn't trigger. Probably because there are
no records being displayed in the main form???
This is not a problem that is intermittent or appears only on this form.
This is a common issue with all my forms that contain subforms.

Thanks again!
 
Hi Paul,

the current event is only triggered on bound forms when records change

what is on your main form? can you describe in more detail what you are
doing and what your goals are?

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top