Lets see if I can explain what I am trying to do
I have a form that I want to enter 4 different date setting in and have them update to a record in a table. I have installed the active X calendar form in my database. I have buttons that open the calendar when they are clicked on
My problem is the date does not change in my form when I select a date from the calendar
Here is my code that I wrote for the calendar I am missing something
Option Compare Database
Private Sub Command4_Click()
Select Case Me.OpenArgs
Case 1
Forms!Issues!OpenedDate = Me.Calendar0
Case 2
Forms!Issues!DueDate = Me.Calendar0
Case 3
Forms!Issues!Updated = Me.Calendar0
Case 4
Forms!Issues!Completed = Me.Calendar0
End Select
DoCmd.Close acForm, "Calendar"
End Sub
Private Sub Form_Load()
Me.Calendar0 = OpenedDate
End Sub
Any help would be appreciated
Greg