writing field to another Table

[NNlogistics]

I have no VBA expertise at all. However, I think I can copy code. Here's my
problem. I would like to wite 3 fields of a form to a table not associated
with the original query or tables that I developed the form from. Maybe the
code can be triggered with the "After Update" event on the filed or maybe the
"On close" event of form, mabe not. So I quess I need to know
If its possible
Code sample
When /where to use it




Thanks for any assistance

 

[Allen Browne]

You could use the AfterUpdate event of the form (not the control), to
Execute an Append or Update query statement so that it adds/edits the record
in the other table.

The more basic question is whether this is a good idea. In general, you
don't want to store dependent values, so if the value in the other table is
dependent on the values you just entered, you don't want to store the
result. Instead, use a calculated field in a query to get the value at the
time you need it.