A
Allan Murphy
Do you have a unique field that identifies the record e.g record_ref as an
autonumber?
Try this code
Private Sub SearchBatter_Click()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[record_ref] = " & str(Me![NameDropDown])
Me.Bookmark = rs.Bookmark
end sub
autonumber?
Try this code
Private Sub SearchBatter_Click()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[record_ref] = " & str(Me![NameDropDown])
Me.Bookmark = rs.Bookmark
end sub