Populate a subform according to selections made in a combobox on the main form

[kiri19]

This is my first project with access
I am working with access 2010 and I am trying to populate a subform "subfrmVisits" according to selections made in a combobox "cboSearch" on the main form "frmClientInfo"
The subform "subfrmVisits" is based on a query: SELECT Visits.Visit, Visits.Need, Visits.[New Client], Visits.[Client ID], Visits.ID
FROM Visits
WHERE (((Visits.[Client ID])=[Forms]![frmClientInfo]![cboSearch]));

In the AfterUpdate event of the "cboSearch" combo I have :

Private Sub cboSearch_Afterupdate()
Me.subfrmVisits.form.requery
End Sub

In the debug window [Forms]![frmClientInfo]![cboSearch])) returns the client ID that matches the selection in the combobox ,
but the subform is always blank.


The link master/child fields for the subform are set to Client ID.

Thank you in advance!

[June7]

If the Master/Child links are set to ClientID then the WHERE clause is not needed in the subform RecordSource and code to requery subform is not necessary.

Search the main form for the client record and the subform visit records will tag along. Several ways to accomplish.
1. filter the form
2. go to desired record

[kiri19]

I set the master(the combo)/child link(cliendID) appropriately and it worked fine , the criteria was not needed and also the query to create the subform was not needed, the record source forms itself when the subform is created...i am getting a grasp of all these things......i am used to oracle...so this is new to me.Thanks a lot for the help.