Requery control on main form causes calculation loop 1

[TimTDP]

In Access 2000 I have a form with a subform.
On the main form is a control with a DLookup function.
This works well. However if I change a record on the subform I want the control with the Dlookup to update. I put the following code in a field on the subform:
Forms![frmRecipe]![txtRecipeCost].Requery

The subform now goes into a permanent "calculation" mode and is in a loop.

Any ideas why?

 

[TimTDP]

Sorry, the code is in the After Update event

 

[TheAceMan1]

How are ya TimTDP:

You need to [blue]ReCalc[/blue] instead. Try:

[blue]   Me.Parent.Parent.[blue]ReCalc[/blue][/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[TimTDP]

Forms![frmRecipe]![txtRecipeCost].Recalc gives me an error 438 - Object doesn't support this property or method

 

[TheAceMan1]

TimTDP . . .

You can't [blue]ReCalc[/blue] a control. [blue]ReCalc[/blue]is for [blue]forms/subforms[/blue] only.

[blue]   Forms!frmRecipe!.Recalc[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886