Full Version: Elusive Type MisMatch.. Error
UtterAccess Discussion Forums > Microsoft® Access > Access Q and A
Larry Larsen
Hi Guy's
Not having a good productive morning..
I'm getting the above error message whilst trying to build a simple sql instruction.. and it will not play.
Can't attach db so here's an image of all the components used..

Process:
Select first combo
Select second combo
Select third combo
(the two txtboxes display the returning/bound columns of second & third combo..)
Image shows:
SQL Statement
Query Results
SQL for the query

Image:


Please slap me on the back of the heads for not seeing the obvious..
thumbup.gif
dannyseager
Hi Larry,

you have the " in the wrong place....

WHERE orderID=" & me.txtOrd & " AND
Larry Larsen
Hi Danny

Thanks.. found about 1 minute after I posted so I got my colleague to slap me on your behalf..

Cheers mate..
thumbup.gif
dannyseager
you're welcome
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.