using Date/Time picker in datasheet view

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

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
 
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.
Click to expand...

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
 
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
 
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?
Click to expand...

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
 
Back
Top