Zod12
asked on
Access Parameter Query with linked tables to SQL Server
Hi,
I am trying to implement cascading combo boxes using the method 2 described in this EE article;
https://www.experts-exchange.com/articles/5950/Cascading-Combos-on-Continuous-Forms-and-Datasheets.html
Basically passing the first combo box value to the second using a parameter query and sorting combo 2 using this parameter.
I have my access tables linked using a DSN less connection with SQL Native Client 11 to the SQL Server.
I get an "ODBC Call error" when I use the parameter in queries based on these linked tables.
I tried using Clng(paramerter) but his makes no difference.
I have searched online extensively but cannot find a specific solution for "odbc call error" when using parameters in queries based on linked tables.
I am trying to implement cascading combo boxes using the method 2 described in this EE article;
https://www.experts-exchange.com/articles/5950/Cascading-Combos-on-Continuous-Forms-and-Datasheets.html
Basically passing the first combo box value to the second using a parameter query and sorting combo 2 using this parameter.
I have my access tables linked using a DSN less connection with SQL Native Client 11 to the SQL Server.
I get an "ODBC Call error" when I use the parameter in queries based on these linked tables.
I tried using Clng(paramerter) but his makes no difference.
I have searched online extensively but cannot find a specific solution for "odbc call error" when using parameters in queries based on linked tables.
Please post a screenshot of the error.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.