When anyone opens a specific form, the error ‘Type Mismatch on: DOCUMENT’ shows up and won’t let the user into the document. Now, I don’t use the variable name ‘Document’ anywhere in the database, and when I debug the form, the error arrives before the QuerySave event… Anyone know what this error is trying to tell me???
Subject: RE: Type Mismatch on: DOCUMENT
Do you have a field named Document on the form? Does the field have a formula in it (Value or Default)? That formula is causing the error. Given the specific error you’re getting, I’d bet that the formula refers to another field which is supposed to contain a number or date/time value, but it doesn’t contain any value when the document is being opened, because no information has yet been typed in that field.
Subject: Type Mismatch on: DOCUMENT
Web or Client?
A QueryOpen or WebQueryOpen agent? If web, anything in the JS Header? Any exiting or entering code on the fields?