Previous Value

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?

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"theitman" wrote in message
...
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?

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" wrote:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"theitman" wrote in message
...
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?

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"theitman" wrote in message
...
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" wrote:

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


"theitman" wrote in message
...
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?