Enter date from previous record to new record

[Randy]

I need a way to enter the date from the current record and carry it over to
a new record automatically. This will cut down on data entry if I enter up
to 50 records with the same date. On a previous Paradox database we would
enter the + key on the 10 key pad and the new record with the previous date
would be entered automatically. Can I do this in access 2000?...Thanks

 

[Rick B]

CTRL + '

 

[Randy]

That works of course, but for fast data entry I need to press one button on
the ten key...Thanks..Randy

 

[Guest]

In the text box you display the date in, set the "Data" properties default
value to be the date() or associate it to a table field that contains the
date you want. In this way each time a new record is created the date will be
pre-populated.

 

[Al Camp]

Mike,
Use the AfterUpdate event of your date field (ex. YourDate) to set the
DefaultValue of that field
YourDate.DefaultValue = "#" & [YourDate] & "#"
The next time you open a new record, that date will be used. If, at any
time you change that date, that new date value will become the default.
hth
Al Camp