Help Regarding List form showing specific information in my table

[natonstan]

Okay so basically below is the table I'm linking to a list box, the field i'm focusing on is the 'Disallowed' field:

Now this is the form i'm linking it too:
As you can see the list box on the right is currently just showing the whole column under the Disallowed list, but I want it to show the specific country, obviously I'm using a single form template but the information changes depending on what country i'm on (I presume I need some kind of Query that uses whatever is shown in the Country box)

I was trying to use SELECT * from tblCountries where [Country]='"&forms!frmCountryDetail!Country&"'" but this is giving me an error from the [Country] tag so this isn't working:

Thanks so much in advance!

 

[Mihail]

Copy and paste the exact query you use.

 

[natonstan]

Copy and paste the exact query you use.

Here's what I was trying to use:

SELECT *
FROM tblCountries.Disallowed
WHERE ((("[Country]")="" & [forms]![frmCountryDetail]![Country] & ""));

But it's not working at all, baring in mind I got this from someone else on another forum so that might be why, I can take more screenshots of specific things if more information is needed?

 

[Mihail]

1) Do you know how to design a query ?
2) Where you try to use this SQL ? In the query window or in VBA ?