error 2427 when retrieving value from subform

[jamaarneen]

Hi everybody

Here is my situation:

I have a mainform, subrform 1 (requests, and subform 2 (orders). each of these subforms have got - among others - a textbox (total) with some functions as control source.
the subforms are working.

I would like to get the value from these totaltexboxes, in a textbox on the mainform. this should be triggered in a click_event from a control on the mainform.

my code in the event will be:

    Me![i]textboxName[/i] = [i]SubformName[/i].Form!txtTotal.Value

but how weird, for subform 1 it's working perfect, but for subform 2, if the value of subform2!textboxTotal is zero, then i'm getting error 2427: "you entered an expression that was no value".
and yes, i tried working with Nz() - the same error!

it's weird because for subform 1 it's working perfect even with a zero value.

thanks in advanced for your help
Ja

 

[Domino2]

What happens, might be wrong, but the syntax I use would be

Me.Textboxname = Forms!NameofMainform!Nameofsubform.Form.txtTotal.value

Above line of code is single line, its cramped up in the window of this reply

 

[jamaarneen]

Thank you,
but I have tried - same error :-(

 

[PHV]

What about this ?
Me!textboxName = Val(SubformName.Form!txtTotal.Value & "")

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

 

[jamaarneen]

Thanks PHV (i just returned to my desk)
but,
still the same error.

again, when the value in subform 2 is greater then zero, then it works. only the zero value returns an error.
and also, the same code will work for subform 1, although it is a zero.

 

[jamaarneen]

Hi again everybody,
No solution? :-(
so I'll have to try to figure out some workaround...(I hate workarounds)