sqloledb date error on bound form

J

Jim Bennett

I create an ADO recordset in code and then assign it to the the Forms
recordset. When I try to modify the text box containing a date and then save
the record I get the following Access message:
"The macro or function set to the BeforeUpdate or ValidationRule property is
preventing Microsoft Access from saving the data in the field"
I DO NOT have anything in either of those events though.
Also, this works fine if I use an ODBC connection instead.

Any ideas?
 
J

Jim Bennett

I forgot to mention that this only fails on date fields. I changed values in
other text boxes without an issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top