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..
Select first combo
Select second combo
Select third combo
(the two txtboxes display the returning/bound columns of second & third combo..)
SQL for the query
Please slap me on the back of the heads for not seeing the obvious..