Dedicated Session of Data Input

[knowshowrosegrows]

I have a database where the user inputs census numbers on various substance
abuse programs. A session of this data input happens daily.

How can I set the form so when they open it and set the date for the census
they are working with it automatically will go into the CensusDate field for
all the records they input during that session.

I don't want them to have to put the date in over and over again, but I also
don't want the system to automatically put Date() in because there is a
chance that they could enter a days worth of data retroactively.

 

[Klatuu]

Use the After Update event of the census date textbox control to set the
default value property to the current value of the control so that when you
go to a new record, it will be in the text box. When you change it to a new
value, it will then retain that value for the remainder of the session or
until the user changes the date.

Private Sub txtCensusDate_AfterUpdate()
Me.txtCensusDate.DefaultValue = Me.txtCensusDate
End Sub

 

[KARL DEWEY]

Have an unbound text box at the top of the form they use for data entry to
enter the date to be used in that session.
Set the Default property of the normal data entry text box to the unbound
text box.
[Forms]![YourFormName]![YourUnboundTextBoxName]