View Single Post
  #9 (permalink)  
Old October 29th, 2003, 11:42 AM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

I have done this before.

________ ______
________| |______|
TextBox Button

The textbox is by default locked, the button opens a form that contains the Calendar control. When you select a value from the calendar control you set the textbox to the calendar value. The textbox can be bound to the table/field.

You can then create two additional textboxes for the Begin time and end time. on the same form.

There is not much code.

try this on the close event of the form containing the calendar

Private Sub Form_Close()
Forms![Form1]![Date].Text = Me.Calendar1.Value
End Sub

Reply With Quote