Hi Everyone.
I have a combo box which navigates to a selected record. Works fine.
What I would like to do is when I apply a filter to the main form the combo box is on, I would like to apply the same filter to the list of records displayed by the combo box.
I have tried many different approaches, but its beyond me so I thought Id better ask the experts.
Here is the usual after update code for the combo box:
Private Sub Combo234_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Specimen Number] = " & Str(Nz(Me![Combo234], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
Any help will be very much appreciated.
Thanks and cheers.
Joe.