Novice
Windows 7 32bit 
Access 2010 32bit
We recently switched our machines to an updated 2010 version of Windows and Access (formally had a 2003 version of Access). Now, when I try to open an old form, I receive the "Type mismatch in expression" error. All of the other forms (including a seemingly identical form) open without the error.
Any suggestions?
VIP
Windows XP Access 2010 32bit
Run Compact & Repair.
Is the form's RecordSource an Access query? Make sure the query will run. Is the RecordSource an SQL statement. Open form in design view. Edit the SQL, make sure it will open recordset.
Rebuild the form.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
type mismatch in expression
data type mismatch in criteria expression
Data type mismatch in criteria expression
Type mismatch in expression /Query
Posting Permissions
Reply With Quote