Recurring data (date) in form

[Cobbler]

I have a form for daily data entry into a table. The date field of this table would normally be populated with the previous day's date but not always. I want to be able to set the date at the beginning of the data entry session and not need to re-enter it with each line.

[Robeen]

Have you tried storing the date that you set at the start of the session in a date variable and then each time you go to a new record populate the date field using the date in your date variable?

[rpeare]

On your data entry form have an unbound text box with the date you want (you can set the default to date()-1 to get yesterday's date). Then whenever a new record is added have it inherit the value in the unbound text box.

For instance let's say you have a form where you're entering hours worked for people on a given day.

On this form you would have a unbound text box called CurrentDay with adefault value of date()-1. On this form you would also have a bound textbox with the name/datasource of WorkDate which would have a combo box with employee names and an employee ID (primary key field), after an employee name is chosen (and the pirmary key is stored), you can have in the ON EXIT event:

Workdate = CurrentDay

and any time you leave the employeeID field your workdate will be populated with the value from the unbound text box

[Robeen]

rpeare,

I think Cobbler wants the option to set the Date at the start of the session.
It is not always going to be Date() -1.

The other thing I wondered about was that on a Monday - would Cobbler want Sunday's date - or Friday's?
That isn't mentioned in Cobbler's post but it crossed my mind.

If that IS a requirement then this might work:

 
'Access 2010.
If Weekday(Date) = 2 Then      'Uses default Sunday as Day 1.
    Workdate = (Date - 3)
Else
    Workdate = (Date - 1)
End If

Either way - It sounds like what is required is the option to set the Date at the start of the session.

[rpeare]

Which is exactly what my proposed fix does :P

Set the date once, optionally setting a default date, but allow it to be changed and any new records that are added inherit the date entered the one time.

[Robeen]

Using your fix -the user either uses the default in Text Box 'CurrentDay' - Date()-1 - or enters an alternate date in the Text Box 'CurrentDay'?

[rpeare]

The user sets the value of CurrentDay. When the form opens that can default to today's date minus one, but the user can modify it to whatever they want. When a new record is added (required fields are present) the CurrentDay field can be copied to the WorkDate field (assuming of course workdate is a bound field)