Syntax for Requery

[willsth]

I am trying to requery a total field which is on my Main Form, when I update a field on my sub-form.

My code is ....

Me.Total Billables.Requery

however [Total Billables] is not in my sub-form.

How do I reference it ???

 

[RuralGuy]

This link should help with the syntax:

http://www.mvps.org/access/forms/frm0031.htm

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[willsth]

Thanks for that seems to be sorted now !!

 

[RuralGuy]

Glad I could help.

RuralGuy (RG for short) aka Allan Bunch MS Access MVP acXP winXP Pro
Please respond to this forum so all may benefit

 

[PHV]

In the AfterUpdate event procedure of the subform's control:
Me.Parent.Form![Total Billables].Requery

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[willsth]

Thanks I've sorted it now