Search combo box linked to subfomr

[billmark]

Hi
I've created a multi field search form with subform. In the combo search, I've updated the criteria in the Row Sources in the properties. I can select the information in the combo box. Please advise how to link this search to filter the corresponding field in the subform without coding.

Regards
Bill

 

[billmark]

Hi
I've coded this as follow but no data in the search combo box. Please advise if it is something wrong in the code:

QUOTE
Private Sub cbofrman_AfterUpdate()

Dim myfrmanager As String
myfrmanager = "SELECT tblFRT.[FR Manager] FROM tblFRT GROUP BY tblFRT.[FR Manager] "
Me.tblFRT_subform.Form.RecordSource = myfrmanager
Me.tblFRT_subform.Form.Requery

End Sub
UNQUOTE


FR Manager is one of the field in the table tblFRT

Regards