Originally Posted by
Lulu
...Using the code provided the data entry clerk will be able to change the field when need be without any issues...
As June7 said, the user can change this at any time; it might help to think of the Default Value as a 'suggestion.' Once data is physically entered into the Control/Field the Default Value remains the same until the user:
- Edits the Control
- Closes the Form
- Closes Access itself
If the user gets tired after entering, say, 100 Records, and decides to go to lunch, closing the Form and/or Access, upon returning the Value will need to be re-entered to start the process again.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007