Enter date from previous record to new record

  • Thread starter Thread starter Randy
  • Start date Start date
R

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
 
That works of course, but for fast data entry I need to press one button on
the ten key...Thanks..Randy
 
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.
 
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
 
Back
Top