editing and appending records

  • Thread starter Thread starter brian mcnamara
  • Start date Start date
B

brian mcnamara

I am new to Microsoft Access. I want to be able to
insert data from an existing record into a new record as
default values. Then I want to be able to edit the data
and have the resulting record be saved as a totally new
record.

Is this possible? I'm lost!

Any help would be greatly appreciated. Thanks!
 
If you're entering records via a form, and you want the values you entered
to be carried forward as the default values for the next record you enter,
there's an example at the following URL.

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

The article describes placing the code in the click event of a command
button. You can also place it in the AfterUpdate event of the control, so
that it will run whenever the value entered in the control changes.

There's also a more detailed explanation and example in the Access <version>
Developer's Handbook, by Ken Getz et all, published by Sybex. (Where
<version> might be 97, 2000, 2002). The example in the book demonstrates how
to allow the user to decide, at run time, which controls should have their
values carried forward as default values.

If that's not the situation, if you want to retrieve values from a record
already stored in a table, then the question becomes 'from *which* record do
you want to retrieve them?'
 
Back
Top