I have a form which opens fine, but I can't change the data in some fields. When I change the recordset type to Dynaset(inconsistent updates), I get a datatype mismatch error. What do I need to check to fix this? There are several different tables and other queries making up the form, would one of them be incompatible with the inconsistent updates setting even though I'm not trying to mess with those fields?

Have you been working with this form alot. I believe that if you have a event named twice in your code you will get this error message. Its been awhile and i cant test it right now but thats to the best of my knowledge anyway sorry i cant be more help