requery 1 subform after activity on another subform

[markjkubicki]

i have a main form frmSpec with multiple subforms: fsubSpec_Cuts and sfrmSched_imagePreview
fsubSpec_Cuts is a continuous form with multiple fields and controls
sfrmSched_imagePreview is a single record form (whose recordset is determined by the records in fsubSpec_Cuts

what i would like is when the used leaves fsubSpec_Cuts (to do something on the main form... or what ever), the other subform requiries


it seems to work when the main form changes record, and the subform consequently...
-> behind the subform fsubSpec_Cuts

Private Sub Form_Current()
Forms![frmSpec]![sfrmSched_imagePreview].Form.Requery
End Sub

BUT
i can't get it to fire otherwise


-> behind the subform fsubSpec_Cuts
(I'm running out of events, which leads me to think that i am TOTALLY in the wrong direction ?)

Private Sub Form_DataChange(ByVal Reason As Long)
   MsgBox "Form_DataChange"
   Forms![frmSpec]!sfrmSched_imagePreview.Form.Requery
End Sub

Private Sub Form_Deactivate()
  MsgBox "Form_Deactivate"
  Forms![frmSpec]!sfrmSched_imagePreview.Form.Requery
End Sub

Private Sub Form_LostFocus()
  MsgBox "Form_LostFocus"
  Forms![frmSpec]!sfrmSched_imagePreview.Form.Requery
End Sub

Private Sub PrintCatalogSheet_AfterUpdate()
  Me.chkTglAllCuts = 0
  MsgBox "PrintCatalogSheet_AfterUpdate"
  Forms![frmSpec]![sfrmSched_imagePreview].Form.Requery
End Sub

Private Sub PrintCatalogSheet_Exit(Cancel As Integer)
  MsgBox "PrintCatalogSheet_Exit()"
  Forms![frmSpec]!sfrmSched_imagePreview.Form.Requery
End Sub

(it would be nicer if it only requiry'd after the user left the subform having done 'something' on it (ie ...it's dirty), but i'll take what i can get


thoughts?


(with thnx in advance,
m.)

[RuralGuy]

Does it help knowing the Form in the SubFormControl will execute its BeforeUpdate event if the user exits after making a change?

[RuralGuy]

Do you have this link bookmarked? http://access.mvps.org/access/forms/frm0031.htm

[markjkubicki]

absolutely have the bookmark !
(it's gospel)

hmmm
before update ? something shifted.... enough to open some other avenues of ponder
thnx!

[June7]

Why would sfrmSched_imagePreview need to be requeried when fsubSpec_Cuts loses focus?

Subform container control has two events available - Enter and Exit.

[markjkubicki]

and... (of course)
it always helps if you remember when to address the container, and when to address the subform inside it

(which fixed the problem ...quickly)