Previous Value

[Guest]

Hello. I'm sure this is an easy one, but I can't seem to figure it out. I
have a form based on a table with only a few fields. When the users enter
data they will enter a number of records at a time. When they click on the
Add Record button they would like 2 of the fields to automatically fill in
with the previous records' values and be able to type over them if possible.
Is there a way to do this?

 

[Allen Browne]

See:
Carry current value of a control to new records
at:
http://www.mvps.org/access/forms/frm0012.htm

Or, if you want to carry all the field values over:
http://allenbrowne.com/ser-24.html

 

[Guest]

Sorry, I'm confused. I don't know alot of coding and the code at the below
site makes no sense to me. Does this work if the control is a bound field to
a table?

 

[Allen Browne]

You need to create a form to achieve this.

The form will be bound to the table.
The text boxes on the form will be bound to the fields of the table.
You can then set the Default Value of the text boxes on the form, so that
they default to the last entry you made.

If you know no VBA code and don't know how to make a form, then you probably
can't do this yet.