MS Access SQL database Query

[Dave]

Came Across some interesting reading, enough for me to see if I can do the
same thing.

This guy writes he has a form that has (1) a combobox where he reads from a
table. (2) command button that runs a query where the criteria is based upon
the combobox setting. This is good as it works with access databases w/o a
problem.

When I try the same thing using a sql database I have no output although I
should have. Here is the setup.

I have a one to many relationship between table a (single) and table b (the
many). I have the combo box setup to read the not primary key of table a.
I bound the primary key field and pushed the command button to run the
query, I get no errors and the results come up empty.

Has anyone had any experience using this? Remember, I'm talking about a SQL
database using Access. Don't embarrase yourself by referring to any Access
databases run by a jet engine....

Thanks,

Dave

 

[K Dales]

Without knowing how you set up the query and what is the code behind the
button there is really no way to be able to tell why you are not getting the
results you expect.