Requery Subform1 from Subform2

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!
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Requery Subform A from Subform B 6
Requery Subform1 from Subform 2 1
Refer to a Sum in Subform2 from Subform1 4
Requery a Sb-Sub Form 3
Call Subform2 from Subform1 on Main form. 1
Where to put the requery? 1
call master form method (to requery subform2) from subform1 5
pupulate control from subform2 to subform1 1

Top