Requery Subform1 from Subform2

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

Guest

Ok, I've tried the syntax a billion different ways, and I can't figure it out.

Main form = FrmBatchControl
Subform 1 = SubFrmTotalComplete
Subform 2 = SubFrmBatchWorkSubform

On the LostFocus event of NumberCompleted on Subform 2
(SubFrmBatchWorkSubform), I want it to requery Subform 1 (SubFrmTotalComplete)

I've tried:
Forms.FrmBatchControl.SubFrmTotalCompleteSubform.Requery
and
Forms!FrmBatchControl!SubFrmTotalCompleteSubform.Form.Requery

This should not be this difficult, but I'm missing something in the Syntax.
I keep getting an error to the effect of "The OLE object you specified is not
an OLE object".

Help!
 
Correction, see below

:

Ok, I've tried the syntax a billion different ways, and I can't figure it out.

Main form = FrmBatchControl
Subform 1 = SubFrmTotalComplete
Subform 2 = SubFrmBatchWorkSubform

On the LostFocus event of NumberCompleted on Subform 2
(SubFrmBatchWorkSubform), I want it to requery Subform 1 (SubFrmTotalComplete)

I've tried:
Forms.FrmBatchControl.SubFrmTotalCompleteSubform.Requery
and
Forms!FrmBatchControl!SubFrmTotalCompleteSubform.Form.Requery

This should not be this difficult, but I'm missing something in the Syntax.

When this code runs, you see Calculating... in the status bar, but the
subform does not update.

Help!
 
Back
Top