Updating db with empty date fields

[VBVines]

I have an access 97 database that has several date fields and text fields. I am using VB6 ado 2.5 to enter data into the fields. Basically text boxes and combo boxes are bound to the database by an adodc. The users don't enter dates into the date fields all the time. Some of the date fields are left blank. WHen this happens I get an error when I try to save. My save button is just an adodc1.recordset.movenext command. Any idea on how I can save updates that include recordsets with fields that have empty date fields.

aspvbwannab

 

[wekkew]

Dear VBVines

When you say you are using text boxes and combo boxes are dates being entered into the text boxes or combo boxes or does the combo box contain a list of dates. Is the combo box a normal combo box or is is a DBCombo1 type of control?

if you're getting the following error -
"Action cancelled by associated object"

Then what may be happening is that the date field of the underlying database has it's "Required" property set to YES. Try setting it to NO and that should clear the error.

If that doesn't work then send me full details of the error and text boxes/combo boxes and I'll have another look.

Kate