how do i get a form to retain the last set of data entered?

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

Guest

I need to create a macro that will update the values/data in the empty fields
to be identical to the values/data in the previous entry.
Is this possible, or is there another way i can achieve this result?
thanks.
 
If you are duplicating information from one record to the next, you have not
designed your database properly. A good database design all but eliminates
duplicate data. You need at least two tables: one for the data that remains
the same from record to record, and another for the data that changes.
Store the primary key value of the each record from the first table into
each related record in the second table and you can use a Join Query to link
them back up.

This process is called Normalization and is very important to understand
before you go much further. I suggest a couple of books: "Database Design
for Mere Mortals" by Michael Hernandez and "Access Database Design and
Programming" by Steve Roman.

Also, on my website there are some tutorials in database design based on the
Hernandez process. You can find them here:
http://www.rogersaccesslibrary.com/TutorialsDesign.html

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Simeon

If you are saying that you want the form's controls to have default values
set to the most recently entered values, you can do this when the form's
data is saved.

If you add code into the BeforeUpdate event of the form, you can:
 
Back
Top