Carry Current Value to new records

  • Thread starter Thread starter DSmith
  • Start date Start date
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.
 
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.
 
Back
Top