I have a combo box on a form that I want to use to choose the record currently being edited on the form. The form is tabbed and based on two tables, CCBPIPE and Shipping. It lets me pick a value in the combo box, but doesn't update the rest of the form.
BORROWER is the name field that I want the user to be able to pick the record by
COMMIT_NO is the primary key
Combo203 is my combo box
Here is my code:
Private Sub Combo203_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[CCBPIPE].[COMMIT_NO] = '" & Me![Combo203] & "'"
Me.Bookmark = rs.Bookmark