Use combobox to control Subform

[bundy75]

I realise this question has been asked before but the answer haven't been able to figure it out.

I have a form with a single combobox "Contact_Type" that is populated form a contact type table. The form also has a subform "Clients_Subform" that is to list all the clients with a particular contact type. Now my combobox defaults to the first contact type and the subform lists those clients.
Two problems

One: When I default the combo box to the second contact type the subform list still gets populated with the clients from the first contact type.

Two:When I select a new contact type from the combobox nothing gets updated. For this I have tried new events in the afterupdate

1 Me.Requery
2 Me.Refresh
3 Me![subform_name].Form.Requery
4 Form![Main_form_name]![subform_name].Requery



Nothing seems to work!!!!!!!!!!

Thanks

[bundy75]

Ok I see the problem

The subform is based of my contact_type table so if I cycle through the records for my contact type table my subform updates as I expect

New Problem

How do I link my combobox to cycle through records???

[bundy75]

Sorry for wasting your time but got it


created the event procedure for combobox event "afterupdate"

' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Contact_Type_Id] = " & Str(Nz(Me![Contact_Type_cb], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark

now it works

Thanks