Hi,

I am a novice at this so I hope this makes sense.  I am trying to apply a
filter to an unbound combo box within the main form 'ArcView_Users' that will
allow me to select a value and filter out only those records in the main form
that contain that value.  The values in the combo come from subform 'Classes'
using this SQL statement in the Row Source of the combo;

Row Source Type - Table/Query
Row Source - SELECT DISTINCT [Classes.CLASS] FROM [Classes] ORDER BY [Classes.
CLASS];
'Which gives me only the unique text values from the Classes' table CLASS
field'

The underlying query for the combo is called-
ClassType
 

What SQL statement or VBA code do I need to add in order to get the records I
need in the Form based on the value I select in the combo box?  Any help
would be appreciated.  

Thanks,

Brian