Requery diagram on subform..? 1

[Kujen]

Hi,

I have diagram on a subform and the subform is placed on a TabControl. I want the diagram to be updated when I change page on the TabControl.

* TabControl is called tabOrders
* FrmDiagram is the name of the subform control
* FrmDiagram is the name of the form inside the subform

If I run:
=============================================
Private Sub tabOrders_Change
Forms![FrmGrund1]!Form.[FrmDiagram].Requery
End Sub
=============================================
..I'll get "Can't find field 'Form'" error 2465

If I change to:
Forms![FrmGrund1]!Form.[FrmDiagram].Requery
..nothing happens.

What can be wrong?

Kent J.

 

[MajP]

Should be
formObject.subformcontrol.form.requery

Something like

Forms![FrmGrund1].frmDiagram.form.requery

the ".form" property returns the form within a subform control. This is a property not a member of a collection so you can not use "!". You do not need to use the name of the form within the subform because ".form" returns the object.

 

[Kujen]

Hi,

Thanks but..
It was actually easier than I thought.
I should be just:
===============================
Private Sub tabOrders_Change
Me.Refresh
End sub
===============================
To update the diagram.

Kent J.

 

[MajP]

Yes, if you requery the mainform all subforms requery.
But you should understand how to properly reference a subform. There will be times when you have multiple subforms on a form and you would only want to requery one of the subforms. Need to understand the difference between referencing an item in a collection and a property.

 

[TheAceMan1]

Kujen . . .

Ditto's on solving your problem, but I agree with [purple]MajP[/purple] ... [purple]you should understand how to properly reference a subform ...[/purple][/blue][/quote]

Have a look here: Refer to Form and Subform properties and controls

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]