ActiveX control on a continuous form

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

Guest

Is there any possible way to have an ActiveX control on a continuous form? I
am using Microsoft's Date Time Picker but want to use it for each date data
entry record on my form (which I need to display multiple records on).

Thanks
 
Try this. Have a main form containing a subform control, and one
unbound calendar control. Code the Current event of the form within the
subform control, to set the calendar (in the main form) to the date of
the current record in the subform control. So the single calendar will
nicely track the current record in the subform control. As for data
entry, just have AfterUpdat of the (unbound) calendar control, write
the selected date value into the relevant control or field of the form
in the subform control.

As they say, the rest will be herstory!

HTH,
TC (MVP Access)
htp://tc2.atspace.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date time picker on the tab control sub form 1
ActiveX control - Date/Time picker 2
set DateTimePicker value to null issue 1
date range using datetimepicker 1
limit display of data on continuous form by date 4
ActiveX Control Calendars 1
Calculate total amount on continuous form line in sub-form 3
Stopwatch Form -- on a Continuous Form 3

Back
Top