default values
--
Hi Bill,
"The calendar will always go to todays date because of the code Now() used."
are you wanting to store date AND time? If so, then Now() would be
correct -- but if you just wanted a Date, the you should use Date()
"The calendar will always go to todays date"
it seeems that you are actually wanting the default value to be this:
dMax([DateField},[Tablename])
"How do I make the date stay at the last date that was enetered?"
dLast([DateField},[Tablename])
assuming that the last record entered has the date that you are looking for
... if you provide more details about your forms and controls, we can be
more specific
"How do I make the 1st, 2nd, and 3rd shift buttons stay at last
shift selected after data has been entered?"
dLast([ShiftField},[Tablename])
assuming that the last record entered has the shift that you are looking for
Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
> I have a form that has the calendar in it and 3 buttons that represent 1st,
> 2nd, and 3rd shift. We input up to 50 forms per day. The forms may be
[quoted text clipped - 3 lines]
> shift selected after data has been entered? This would allow the data entry
> person not to have to change date or shift if forms are grouped together.