Active X -Calendar 1

[rhonda11]

I have a text field for delivery date on a form that a user would type in the date, it is a required field (Is not Null). This field data type is Date/Time with a shortdate format. I currently doing some changes and created a Date and time picker (Active X), which is great. I went into the property and replaced the calendar control source to Delivery date and deleted the delivery date text field that way they can select the date on the calendar. However, when I ran the form and click on new record an error message populate "Can't set value to Null when Checkbox Property=False". I know it on the active-x control calendar.
Any idea what's going on, I'm new with this control.

Thanks in advance

 

[colinb]

Try putting a default value in the Table for the [DeliveryDate] field of, say Date()

If I have understood your question this should work.

 

[rhonda11]

That works!! Thank you so much, Merry Christmas