How do I make Access fields repeat previously entered data?

[Guest]

I seem to remember that while entering data in Access fields, the program
would automatically pop in previously entered data. For example, if I were
entering the dates for client appointments and I had a slew of 1 March 2006
appointments to schedule, Access would automatically pop the "1 March 2006"
date into the field as soon as I entered the "1"

Now I'm thinking this may be something that has to be activated. I'm in a
new job and working with a different Office Suite. My Access isn't popping
repeat data into the fields like I expect it to.

What do I do!!?

Thanks!

 

[Al Camp]

Steve,
I think you're referring to making the last date entry the default value
for the field, so it will auto-magically enter on new records.
Say you had a field called StartDate, and you plan to enter 10 records
with that date.
On the AfterUpdate event of StartDate, run this code...
Private Sub StartDate_AfterUpdate()
StartDate.DefaultValue = "#" & StartDate & "#"
End Sub

That StartDate will be in effect until a new StartDate is entered, and
then that StartDate becomes the new default.

 

[Joseph Meehan]

I seem to remember that while entering data in Access fields, the
program would automatically pop in previously entered data. For
example, if I were entering the dates for client appointments and I
had a slew of 1 March 2006 appointments to schedule, Access would
automatically pop the "1 March 2006" date into the field as soon as I
entered the "1"

Now I'm thinking this may be something that has to be activated. I'm
in a new job and working with a different Office Suite. My Access
isn't popping repeat data into the fields like I expect it to.

What do I do!!?

Thanks!

Not exactly what you want (I think Al took care of that) but did you
know that a control (') will copy the data from the prior record in any
field? Note that is a (control-single qoute)