I have a library table. When entering the data for the County, I want it to
lookup from the County table and have a list to choose from. That works just
fine.

The next field is Municipality. I have a Municipality table for lookup, but
I only want to show the Municipalities that come from the County just chosen.

This is what I have, but it doesn't work.

SELECT Municipalities.Municipality, Municipalities.MUNCode
FROM Municipalities RIGHT JOIN Counties ON Municipalities.CTYCode =
Counties.CTYCode
WHERE (((Municipalities.CTYCode)=[Counties]![CTYCode]));

Any help would be greatly appreciated.

Thanks