Retrieving Value From Subform Only Works In Break Mode

[(PeteCresswell)]

The code:
-------------------------------------------------------------

2550 With Me.subSecurity.Form
2551 If Me.subTrades.Enabled = True Then
2552 Me.subTrades.Form!txtParTotal.Requery
2553 curParTotal = Me.subTrades.Form!txtParTotal.Value
'MsgBox curParTotal
2554 !txtParTotal.Value = curParTotal
2555 !txtParTotal.Requery
2556 End If
2559 End With
-------------------------------------------------------------

If I put a break on line 2552 or any line above it, the value
gets retrieved and everything works a-ok.

But with a break on line 2553 or no break at all, it's as if
Me.subTrades.Form!txtParTotal.Value = 0.

Anybody been here?

 

[Pieter Wijnen]

What is TxtParTotal (ComboBox, TextBox)?
If it's a calculated field a recalc may be what you want

Pieter

 

[(PeteCresswell)]

Per (PeteCresswell):

I'll hook into the client site right now
and try Recalc.

Can't find anything that looks like Recalculate.

..Requery did not help and I didn't have any luck with DoEvents
either.

I'm still wondering what magic the break invokes....

 

[Pieter Wijnen]

Sorry, It's The (sub) Form that needs the recalc

Pieter