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_AfterUpdate()
dim db as database
dim rs as recordset
set db=current.Db
set rs=db.OpenRecordset("yourtablename",dbOpenDynaset)
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.google.c om...
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