Advice on Default Value

[rm]

I have struggled tremedously with setting a default value on a data
entry form. I keep running into road blocks. I do not think that I am
taking the right approach - I need advice from the experts on how to
handle the situation. The scenario is: A user is entering a set of
values used to track an activity. The data consists of a name, a date
and a quantity. In the table the default value for the date is Date().
For the most part data is entered on the day of the activity. But that
is not a constant - data isn't always entered on the day that the
activity takes place. To help the data entry person there is a check
box on the form which, when checked will hold the value of the last
date entered for the next N number of records added where the check
box is "checked" (value = True or -1) . For example if a clerk had 100
records to enter on July 22nd for activity that took place on July 20
the clerk would enter 20 july check the box and then go on about his/
her merry way entering records without having to back date the records
100 times. For the sake of sample the form is frmEntry, the date field
is txtDate and the check box is cbxKeep. What events should I use?
What approach would you - the Access Guru that has been kind (or
bored) enough to even consider answering this question - take to solve
this problem. I am not asking for written code. I can do that. Just
not sure what events to use to solve this issue.

 

[Allen Browne]

If you can't get the Default Value of the control to work, use the
BeforeInsert event procedure of the form to assign the value from the
unbound txt box to the actual date box.

 

[bcap]

Looks like you need to be using the form's AfterUpdate event.