I have a form with a calendar-control on it.

The source of this calendar is the field "DATE", which is in the table "LOGS".
The default value of field DATE in table LOGS is Date(), so when I add a new record on my form (by clicking on the right arrow), the calendar always shows the date of today...

I want to change that. I want the calendar to show the latest date entered in the table (dmax?)

I tried dmax in the default value of the field "DATE", but that doesn't work.
I tried with vba code, to update the calendar, but this generates errors...


Can someone help please?

Thanks