Tab changes back to default value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the default value for a control on a form set to Date(). Most often
the current date will be the entry, but I need to be able to change the date
if necessary. If I change the date and tab to the next field, the date
changes back to the default date. If I use the mouse, it retains the new
value I entered. I don't have any events set after update, not sure why this
is happening. Can someone help? Thanks! Mary
 
Mary said:
I have the default value for a control on a form set to Date(). Most
often the current date will be the entry, but I need to be able to
change the date if necessary. If I change the date and tab to the
next field, the date changes back to the default date. If I use the
mouse, it retains the new value I entered. I don't have any events
set after update, not sure why this is happening. Can someone help?
Thanks! Mary
Click to expand...

What code *do* you have in various events? I'm guessing that there's
code doing this that you've overlooked.
 
I've looked at the events for the form itself and every control, there are
none set. This is a subform if that would make a difference. On the main
form, the only event set is to populate the Task Worker control, nothing to
do with the date. Any other ideas?
 
Mary said:
I've looked at the events for the form itself and every control,
there are none set. This is a subform if that would make a
difference. On the main form, the only event set is to populate the
Task Worker control, nothing to do with the date. Any other ideas?
Click to expand...

Are you sure your act of tabbing out of the control isn't shifting to a
new record? That's the only thing I can think of. If that's not it,
then I'm at a loss unless I can examine the database personally. If
you'd like to send me a cut-down copy of your database, containing only
the elements necessary to demonstrate the problem, compacted and then
zipped to less than 1MB in size (preferably much smaller) -- I'll have
a look at it, time permitting. You can send it to the address derived
by removing NO SPAM from the reply address of this message, or you can
get the address from my web site..
 
You're right, it was going to a new record. I had that field last in the tab
order because it's normally the default value. I changed the tab order and
it's working now. Thanks!
 
Back
Top