Syntax error (Missing operator) in query expression

Hello,

I am working in a database where I am trying to link two combo boxes to where when a specific selection from one box (dictionary) gives specific choices in the drop down in the other combo box.

Here is where I obtained my information and what I have so far as well as the error I am reciving:

Syntax error (Missing operator) in query expression 'Maint DBI.Description'.

I based my information on example 2 from the site :

HTML Code: 

This example uses a single table which provides data for the Row Source of both combo boxes. The table (Maint DBI) contains two fields, one for the Dictionary and the other for the Description to which it belongs...


I first created a standard list on an excel file and imported it. I named my imported file (Maint DBI).

Dictionary Description
Physician Physician
Physician Ref Physician
Referral Outside Fac
Referral Clinical Liaison
Referral Discharge Planner
Referral Multi Referrals

I set The Row Source property of the Dictionary combo box as Physician on the first line and Referral on the second line.

I then placed the following code on the After Update event of the Dictionary combo box:

Please Login or Register  to view this content.

I am new to writing VBA. I am not sure how to set The Row Source property of the Dictionary combo box to take the form of a SQL statement to represent a query of the Maint DBI table returning the unique values found in the Description field, sorted into ascending order:

Please Login or Register  to view this content.

Please let me know if I am confusing on any part.

thanks!!

Since my previous post I have set my Row type set as: Table/Query I have My row source set with the SQL statment in "Write SQL query Builder" :

Please Login or Register  to view this content.