Modify a record and save as a new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, This is very interesting and hard for me at least. I am working on a
db for a client where he wants to be able to modify the record in one field
and then save that record as a new record while leaving the original as it
is. For example, the record has location of detroit, then he wants to change
the location to chicage and add it as a new record and leave the original as
it is with detroit location. I would REALLY appreciate your help since i am
not very good with vba programing.

Asif
 
Hi,

Should start by making a copy of the record and then modify that copy
(or scrap the copy to undo the process).


Hoping it may help,
Vanderghast, Access MVP
 
Michel, That is what i was thinking too. First copy the record, make the
changes and then save it. However, how would i do that behind the button
programically? I appreciate your time.
 
Hi,


Starts with the query wizard button "Record Operations", "Duplicate
Record", "Copy To New Record".



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top