Combo Boxes for Zip Code to autofill in City & State

I have reviewed other problems/answers similar to mine and can not make those answers work in my db.  I am creating a DB using Access 2007 for employees to complete an IRS reporting form to collect info to ultimately send to the IRS.  The forms do NOT go directly to the IRS.  It is only for gathering info that the accountant will accumulate into his system to confirm and transmit.

I am simply wanting the Employee to key the Form's Zip code and it autopopulate the Zip Code City and State.  I keep getting a "Syntax error in From clause" error when I use code below in the "Row Source" field in PostalCity

Here is what I have.

I have 4 tables:
1) IRS Form Info;
2) City;
3) State Abbreviations;
4) PostalCode

I have populated the PostalCodes table with all zip codes within my region
I have linked (via Lookup Wizard) the PostalCode table to my State Abbreviations table
I have linked (via Lookup Wizard) the PostalCode table to my City table
I have linked (via Lookup Wizard) the City to my State Abbreviations table (since City names can be duplicated by many states each name will be unique by a CityID)

Table:
PostalCode
Fields:
1) PostalCodeID
2) PostalCode - The unique Zip Code
3) StateID - Lookup field to "State Abbreviations" Table
4) CityCode - Lookup field to "City" Table

Table:
City
Fields;
1) CityID
2) CityName
3) StateID - This is a lookup to the State Abbreviations table

Table:
State Abbreviations
Fields:
1) StateID
2) State - This is the full state name
3) PostalState - This is the 2 letter Postal State Abbreviation

Table:
IRS Form Info
Fields;
1) TransID
2) CustomerLastName
3) CustomerFirstName
4) CustomerAddress
5) CustomerPostalCode
6) CustomerCity
7) CustomerState
8) CustomerAmount
9) TransDate



Thanks in Advance

I tried code similar to the below

RowSource;
SELECT City.CityID, City.CityName FROM City JOIN PostalCode ON PostalCode.CityCode = City.CityID

I get a "From" Error

Select allOpen in new window