Bob,
I have a drop down combo box that selects the name from list:
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[CustName] = '" & Me![Combo89] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
I...