I have a tab control in a main form ... each tab has a subform.
I have a public function callable from any subform that initiates a form main requery and each subform has its own requery function
issues:
when access starts the main form automatically requeries all of the subforms which is most unwanted ... I set a global flag in the MAIN FORM LOAD that stops this from happening expect when I am debugging access doesn't appear to be reseting all objects
I only want the current tab to requery once on a change which should be initiated from the Main Form ... it appears when I attempt to do this, Access does the main form requery but then does an automatic requery of the subform again so I'm getting multiple updates ... I am passing a picture between thumbnail and full screen but because of the double requery the picture object is loaded twice and the second requery wipes out the passed pic
I have a public function callable from any subform that initiates a form main requery and each subform has its own requery function
issues:
when access starts the main form automatically requeries all of the subforms which is most unwanted ... I set a global flag in the MAIN FORM LOAD that stops this from happening expect when I am debugging access doesn't appear to be reseting all objects
I only want the current tab to requery once on a change which should be initiated from the Main Form ... it appears when I attempt to do this, Access does the main form requery but then does an automatic requery of the subform again so I'm getting multiple updates ... I am passing a picture between thumbnail and full screen but because of the double requery the picture object is loaded twice and the second requery wipes out the passed pic