[AccessD] Combo box question

I have a form with a subform on it. Is it possible to have a combo box
that would limit subform to its selection ?
the combo box now shows only distinct records that are in a column -
getting them straight grom the query the subform is based on. (1,2,4)
I need to specify which column of the subform should equal that selection
i am trying

Private Sub cmbFrm1_AfterUpdate()
Me.FormQuery1.SourceObject = "'Select * From FormQuery Where AppsID =' &
cmbFrm1.text & '"'
End Sub


Query name - FormQuery
Subform Name - FormQuery1
Column name that should equal selection - AppsID


-----------------------------------------
Make Money and Find Love at Finally.com
http://www.finally.com/?link=webmail