Use an event to trigger the update, either a button click, or the after
update event of the field, then use a recordset to add the data to the
table.
Something like.....
Private sub Yourfield_After Update()
dim db as database
dim rs as recordset
set db=current.Db
set rs=db.OpenRecor dset("yourtable name",dbOpenDyn aset)
with rs
..addnew
!TableField = Your field * 10
..update
end with
set rs=nothing
set db=nothing
end sub
Probably easier ways too.
Gerry Abbott
"Won Mee" <wo****@comcast .net> wrote in message
news:4e******** *************** ***@posting.goo gle.com...
I want to enter a value in a field and for that value that was entered
to be multiplyed by 10 and then stored in a table. How do I do this?
For example:
[testCalc]=[testCalc]*10;
Thanks,
Won Mee