update method not working only on database fields set with date/time

[Bebe]

when I do an update in my program fields that are set as text fields in the access database will update; however, if the field is set to date/time in the database it will not update and i receive the error message:

runtime 3426
this action was cancelled by an associated object

what would cause this? anyone have any ideas?

[Bebe]

any fields that have a property of text in the database will update any fields that have a property of date/time will not update; this is what i meant

thanks