I placed a calendar control on my form yet the field it should update will only update if I click on calendar date I want then click back in the field it should go in.

This isn't right is it.

Any help.
thank you Ian

Did you create a On Click subroutine for the calendar? If you Calendar is named Calendar then code like this should do the trick:

Private Sub Calendar_Click()
Me.TextFieldToGetDate = Me.Calendar.Value
End Sub

Thanks for that Jack...I have got it working and found out I needed the code below which you add through the bulid event (with a right click), no wonder I couldn't find it in the properties!!


Sub ctlCalendar_Click()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
End Sub