Repeating date entries

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

I have a form, where the user enters current week's data for each employee.
Right now, the user has to enter the date on each line. Is it possible to
use a text box or table, where the user selects the date once, and it will
fill the date field with that date?
Annelie
 
If the date is the one on which the user is entering the data then you can
put
Date()
next to Default Value for that field.

Or, after typing the date once, in the next record you can press Ctrl + '
which automatically copies into a field what was in that field in the
previous record.

Or, if the date is never missed out, you can make an Update query which adds
the Maximum date you have typed in (use DMax in your UpdateTo row of the
query) and put IsNull in the criteria row so it only adds this value to new,
undated records. Put a command button in your form to run this query.
Evi
 
Back
Top