Date Default Record to Record

[Guest]

I have a date default set on Got focus for a series of critical date fields
on a form.

If Isnull(me.Ready_Date) Then
me.Ready_Date.value = Date
Cancel = True
End If

However when a user uses their mouse roller and moves from one record to
another, and their cursor was on a date on the previous record the cursor
stays on that date on the next record(s) and populates the field.

How can I set the field location on the mouse move to a different,
non-defaulted field like [Customer]?

Should I be using "On Update" instead on "On Got Focus"?

Since the date is an OLE DTPicker, I am limited on the Event choices.

Thanks

 

[Guest]

If the date is a bound control, you can use the Default Value property in the
form or in the column in the table to automatically populate the date for new
records. This is the best way to handle this and I think it will eliminate
your problems.

Barry