Dlookup function (i guess)

[spleewars]

guys, to be in short - a textbox named (totalsamount) is set with a formula to automatically add and subtract some other field boxes in the form. now here is my question; i have a a text box named (deposit). 'deposit' need to be filled (duplicated) automatically with the result written in 'totalsamount'.

I messed up although i know im making a small mistake somwhere.

thanks

 

[plog]

Why not copy the formula from totals amount to this new textbox?

 

[spleewars]

yeah, till today that was the ideal - copy and paste. but long ago i have performed this automation and would be grateful if someone could enlighten me again

 

[spleewars]

... any help please?

 

[plog]

Why do you need the data to appear twice in the form? Are you trying to save the calculated value to a table?

 

[spleewars]

Why do you need the data to appear twice in the form? Are you trying to save the calculated value to a table?

Yes, that my main intension, to save the calculated data in the table...

 

[vbaInet]

Calculated values should NOT be saved.