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
Code:
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 ?)
Code:
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.)