date time picker on the tab control sub form

[iccsi]

I put a date time picker on the tab control on a sub form and just
realized that the Access does not like ActiveX controls on the tab
form.

I tried to put text controls to bound fields and take out the record
source on the date time picker and synchronize them on
DateTimePickerExit even and on Tab Changes.

It works for single form, but the date time picker always has same
value, because it does not bound a field.

Because the unbound datetimepicker is on the details, are there any
way to let datetimepicker to synchronize the records on the details?


Your information is great appreciated,

 

[Jeanette Cunningham]

Hi iccsi,
if you are looking for an easy-to-use date-time-picker that is not an
active-x but purely an access form, there is one here
http://allenbrowne.com/ser-51.html

This one works on a subform as long the date field is a bound field.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia