clearing drop down menus in access

[chembuff1982]

I have two drop down combo boxes combo27 and combo29 my code in combo27 is this

Private Sub Combo27_AfterUpdate()
Dim rs As Object
Set rs = Me.Recordset.Clone
    rs.FindFirst "[CompanyID] = " & Str(Nz(Me![Combo27], 0))
    If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

in my rowsource for combo29 I have

[Forms]![frmCustomers]![Combo27]

However, when I change my mind on combo27 combo29 isn't changing to my new parameter.

for example if I pick client 1 in combo27 it will give me a test result, but if I go back and click client2 combo29 still stays with client1's results. How do I clear this or reupdate it?

[Rabbit]

Put this at the end of that code:

Me.Combo29.Requery

[chembuff1982]

Thankyou so much for your help, it works great now.

[Rabbit]

Not a problem, good luck.