using Date/Time picker in datasheet view

[Guest]

Is it possible to use the Date/Time picker control in a subform? I have a
subform and I'd like to allow my users to use the control to choose the date
in the subform for updating the records relating to the main form.

Thanks in advance,
Emily

 

[Tim Ferguson]

Is it possible to use the Date/Time picker control in a subform? I
have a subform and I'd like to allow my users to use the control to
choose the date in the subform for updating the records relating to
the main form.

You can use anything you like in a subform... just remember that all the
coding etc belongs in the code module of the form that you are embedding,
not into the parent, if you see what I mean.

All the best


Tim F

 

[Guest]

I tried adding the DateTime picker control to the subform by opening the
subform in design vew. When I looked at it in datasheet view, the control
wasn't there. Any suggestions?

Thanks,
Emily

 

[Tim Ferguson]

I tried adding the DateTime picker control to the subform by opening
the subform in design vew. When I looked at it in datasheet view, the
control wasn't there. Any suggestions?

Datasheets in general are pretty underpowered, although I did not realise
that they squashed ActiveX controls. Try using the thing in Continuous
Forms mode instead.

All the best



Tim F