Add new row to table with only a few fields changing

  • Thread starter Thread starter EricK
  • Start date Start date
E

EricK

We have a database table (in Access 97) which needs a new row added each
month but only a handful of the fields change regularly, the rest almost
always stay the same.

What is the easiest way to ask for a few inputs from the user and
automatically update the table with those new values but everything else
copying over from the last row?

Thanks

Eric
 
See:
Assign default values from the last record
at:
http://allenbrowne.com/ser-24.html

It's basically copy'n'paste code that duplicates all the fields from the
previous record as soon as you start typing into a new record. You can then
change the fields you need.
 
Back
Top