Syntax Error For Null Date Field

[klove1209]

Good afternoon,

I am currently working on this unbounded form that has numerous date fields. I wanted to know if it is possible to save data in a form, with a null date field. I am currently getting an error, and would like to know if there is a way around it. I am doing this feature just in case users do not need to enter a date for a specific record.

Also, when the form is loaded all the controls (checkbox, combobox, listbox, and textbox) are set to Null.

An urgent response is needed!!!

Thanks

[FishVal]

Hi, klove1209.

So if I got it right you need controls to be populated with default values in the unbound form.

I think you have two options.

• Store default values in Control.Tag property and set Control.Value to Control.Tag on form load.
• Bind the form to a table with one record containing default field values and take measures to prevent saving to the table (i.e. remove navigation buttons, call Form.Undo in Form_BeforeUpda te event handler.