Ask a new question

"type mismatch in expression" how to find the problem?

When I start a form in form view, I receive the message "type mismatch in expression".  I understand the error, but no information about where the error is located is given with the message.  I do I find the expression that is causing the error?  The form is huge with several sub forms.  I looked through and found a few problems, but I cannot find the "last" one.
Answer
Answer

Open each of the subforms by itself. Does the type mismatch error occur for one of them? f so, that's the one you need to investigate. Otherwise, it's the main form.

If the record source of the problem form is a query or sql statement, can you open that by itself? If so, you'll have to investigate the query. Otherwise, look at the record source of each of the combo boxes and list boxes on the form.

---
Best wishes, HansV
https://www.eileenslounge.com

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer
Answer
I would start by runing the underlying queries by themselves.  If not in individual query then copy form, remove subforms, and test. Then test with one sub form, etc.
Build a little, test a little

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated August 31, 2023 Views 34,166 Applies to: