DTPicker/RecordSource Clash

M

Martin Dashper

I have a bound form containing a DTPicker (MSComCtl2.DTPicker.2) which
I open via a button on another form, and, on opening this subform, I
need to assign a date value to the DTPicker.

Normally this assignment works fine (with a hard-wired Record Source),
but when I attempt to change the Record Source in the Form_Open or
Form_Load method and then assign the date value, I get a runtime error
(DTPicker returned the error: An error ocurred in a call to the
Windows Date and Time Picker control)

Is there a way for the subform to change it's own Record Source,
whilst retaining functionality of the DTPicker?
Alternatively, is it possible to change the form's Record Source from
the calling form before the subform is opened?

Martin Dashper
 

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

Top