working with formulas on textfields and storing them in tables!

[axess_nab]

No one has an idea of what I'm doing wrong? I really need help :S

[pbaldy]

I just got back from vacation, but I did look at it right before leaving. I recall having trouble figuring out what was supposed to go where. I'll try to look again, but as you might guess I've got a lot piled up right now.

[axess_nab]

pbaldy I do appreciate a lot the time you've spent answering my thread, Thank you so much! If you have any question please ask I guess you do have a lot of questions because I don't have an structured way to program yet! And it's in other language but please feel free to ask! Thanks again

[axess_nab]

Pbaldy I made a braketrhough using a macro and the setvalue action combined with some events I know can store the calculated values but the problem is as I sum the Subtotal text box and the IVA text box the Total is given rounded and I need to be able to keep the decimal values. I already have checked the properties of both text box and they are both currency and the decimal places are set up to automatic. Do you have any idea of what I'm doing wrong? I'll give you the expression I'm using in my macro:
CCur([Formularios]![frmEntradasMain]![Subtotal]+[Formularios]![frmEntradasMain]![IVA])

where frmEntradasMain is the form I'm using and Subtotal and IVA are the name of the text boxes I'm summing on it. I hope you can help me!

[pbaldy]

What is the data type of the target field?

[axess_nab]

It's the same type, currency with decimal set to automatic

[pbaldy]

To clarify, I mean the data type of the field in the underlying table, not the textbox.