Importing data from an Access database and filtering it base on two columns of the table

[Dave Hauer]

I have a combo box that I am filtering to fill a combo box. Originally, I
had a table with that had two field and the string that I used to filter was
as follows:
strSQL = "SELECT [DienCodes] " & "from Codes " & "WHERE [CodeID] =" & CatID
& " " & "ORDER BY [DienCodes];"

I want to add a nother filer item (WHERE) and have tried the following mod.
to the above string::

strSQL = "SELECT [DienCodes] " & "from Codes " & "WHERE [CodeID] =" & CatID
& " " & "AND" & " " & "[CountryCode] =" & CountryCode & " " & "ORDER BY
[DienCodes];"


and this variation:

strSQL = "SELECT [DienCodes] " & "from Codes " & "WHERE [CodeID] =" & CatID
& " " & "AND" & " " & "WHERE[CountryCode] =" & CountryCode & " " & "ORDER BY
[DienCodes];"

Can you tell me if I am doing something wrong because the above string will
not filter by the twotable field identifiers, CodeID and CountryCode.

Any assistance is greatly appreciated!

DH