Carry Current Value to new records

D

DSmith

What's the best way to carry forward a current value of a record so that
it's automatically entered for all new records? I looked at the suggestion
on The Access Web but didn't really understand where to put the code so that
it would affect just the one field. Thanks.
 
R

Rick B

Please search and read previous posts before adding a new thread. Your
question is very common. Here is some information previously posted...

Use the AfterUpdate event of the control to set its Default Value.

Details:

http://www.mvps.org/access/forms/frm0012.htm



An alternative approach is to use the BeforeInsert event of the form to copy
the values from the last record:

http://allenbrowne.com/ser-24.html




The first option goes in the AfterUpdate for the control. Your code states
which controls you are affecting.
 
Top