Help Regarding List form linked showing specific information in my table

[natonstan]

Firstly here's my table, as you can see I have a list of countries and a list of "Disallowed suppliers".



Now on the list I have on the right I want the specific countries suppliers to be displayed, as you can see I managed to do it with the country name and currency as I'm using a single form linked to a table.


Here's the form in Design View so you can get an idea of what I was trying to do, basically as you can see it's simply showing the whole "Disallowed" column from my table, can anyone help me with a query to run or maybe some code that will only display the specific data found in that countries cell?

Thanks in advance

[ranman256]

Your query must reference the country shown in the form:


qry.sql = Select * from tDisallowed where [country] = '" & forms!frmCountryDetail!Country & "'"

[natonstan]

Your query must reference the country shown in the form:


qry.sql = Select * from tDisallowed where [country] = '" & forms!frmCountryDetail!Country & "'"

I'm COMPLETELY new to SQL sorry, is there any chance you could give me the exact Query I should run?

I figured it would be a problem with my actual query but just had no idea what it should be exactly

[natonstan]

Here's the details for the Country box, and I've tried using both [Country] and [txtCountry] in my query, but still get the same error

[natonstan]

Sorry for posting again. I figured it might make things easier if I moved it over to the same table, here's my new table and I have the "Disallowed" field on there.