Sorry about that I'm using Access 2007. I've used the calendar in regular forms where I create a text box set the format "Show date picker" to "for Dates" What I'm trying to do now is I have a command button that ask user if they want to use the current date, (match date),
- If vmark = vbYes Then
-
vmsg = "Use match date or select a date? Yes to use match date. No to select a date, Cancel to exit"
-
vmsgans = MsgBox(vmsg, vbYesNoCancel)
-
If vmsgans = vbCancel Then
-
Exit Sub
-
End If
-
If vmsgans = vbYes Then
-
StrSql = "Update masterb set Family_Plan = true, Releasesigned = #" & VShootDate & "# where current_match = true"
-
DoCmd.RunSQL (StrSql)
-
End If
-
If vmsgans = vbNo Then
-
-
-
-
End If
-
End If
-
I would like to display a calendar for the user to be able to select a date. I've thought about having a text box set as for the date and invisible, and if the user select No, then make the text box visible and then after the user selects the date update the file with the proper information.
When I tried this the program doesn't stop when I give the focus to the now visible date text box and the update statement doesn't have the date.
So what do you think, I'm probably still not clear so if you need more information let me know.
Thanks for you help.