filtering subform with listbox from main form

[icemonster]

so i have a form with a subform, how do i filter the record using a listbox?

i tried doing this

Private Sub lstClientList_Click()
DoCmd.Requery
Forms.[navfrmClient].[NavigationSubform].RecordsetClone.FindFirst "[ClientID] = " & Me![lstClientList] & ""
If Not Forms![navfrmClient]![NavigationSubform].RecordsetClone.NoMatch Then
   Forms![navfrmClient]![NavigationSubform].Bookmark = Forms![navfrmClient]![NavigationSubform].RecordsetClone.Bookmark
Else
   MsgBox "Could not locate [" & Me![lstClientList] & "]"
End If
End Sub

but doesnt seem to work.

i get run time errior 438

 

[Jeanette Cunningham]

Assuming that you have set the Link Child and Link Master fields, then you can use the listbox to filter just the main form and access will automatically show you the matching records in the subform. This is much the same as using a combo instead of a listbox.