Link to home
Start Free TrialLog in
Avatar of Zod12
Zod12Flag for Ireland

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.
Avatar of Vadim Rapp
Vadim Rapp
Flag of United States of America image

Please post a screenshot of the error.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members 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.