Updating Recordset

[dbnewbie]

I have a database form with a tab control, combo boxes, and subforms. The main form has a combo box with a list of clients. When I first created the form, there were only 20 clients. I recently added 15 more to the client table (by hand - not through the form), but the form has not updated itself with these new records. It acts like the information has not been entered into the tables when it has been. So when I select a newly added client, I end up seeing fields populated with the first client's information.

This is the code I have for the combo box afterUpdate method:
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Clients_ClientID] = " & Str(Nz(Me![Combo50], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark


I would guess that I would just need to update the recordset...
Any ideas?

Thanks,
dbnewbie

 

[dbnewbie]

hmmmmm......weird

I'm not quite sure what happened (or what changed), but it is now working properly. The form has recognized the new clients and the recordset has been updated from 20 to 35.