Current date on cool datepicker - SJMcAbney?

[PierreR]

How can I maintain the current date on this date-picker that Miles O aka SJMcAbney provided? The value line doesn't want to take anything but a date-constant. It has not worked from the VBE either.

Could SJMcAbney please help?

 

[Mile-O]

Press the button now.

 

[PierreR]

Works good! Thanks SJ.

I would like ctlPicker to keep its Value at the current date AUTOMATICALLY, and that is what I could not make work. I think because of the sequence of the events. The error message says that it is read-only.

In what Event (of the form or ctlPicker) could the line be applied safely?

Me.ctlPicker.Value = Date

 

[Mile-O]

In what Event (of the form or ctlPicker) could the line be applied safely?

The line works fine but I don't know what you mean by automatically - at what moment?

I'm guessing you mean on switching between records. If so, then the answer is the Current event.

 

[PierreR]

Do you think it would be okay to put it in the On_Enter Event of the ctlPicker itself?

 

[PierreR]

I mean without having to click a button - I think it does work well in the On_Enter of the ctlPicker. I'll use it for a few days to test it.

 

[PierreR]

Thanks for your invaluable presence on this forum.