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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Carry over values from previous record 6
carry over field 4
Carrying over a new total figure from previous record to new recor 1
Continuous form carry forward value 3
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1
Carrying a field value to another form 1
Copy record info into new form 0
Access Use a form button if most data is to be duplicated on another new record. 0

Back
Top