search criteria based on other combox

[NewStudent]

Hi, everyone,

How to created combox depend on other combox? I already created one cobox that works for single search. I want to create another combox "cbxDOB" that depend on "cbxlname".

The following codes only works for single search "cbxlname". Finally, I need to get search for " lastname + DOB".

Private Sub cbxlname_AfterUpdate()
Dim strSQL As String
strSQL = "select * From hackney_log where lastname = '" & Me.cbxlname & "'"
Me.RecordSource = strSQL

Me.cbxpermit = Null
Me.Requery

End Sub

Many thanks.
Wendy