Could someone please tell me what Im doing wrong? I want to retrieve a record from my table (business details) based on the business selected in a drop down. But my code says its a new business every time, regardless of whether an existing business is chosen from the drop down:
Private Sub Combo135_AfterUpdate()
Dim rs As DAO.Recordset
'Search in the clone set.
Set rs = Me.RecordsetClone
rs.FindFirst "[Business Name] = " & Me.Combo135
If rs.NoMatch Then
MsgBox "New Business?"
Else
'Display the found record in the form.
Me.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End Sub
Private Sub Combo135_AfterUpdate()
Dim rs As DAO.Recordset
'Search in the clone set.
Set rs = Me.RecordsetClone
rs.FindFirst "[Business Name] = " & Me.Combo135
If rs.NoMatch Then
MsgBox "New Business?"
Else
'Display the found record in the form.
Me.Bookmark = rs.Bookmark
End If
Set rs = Nothing
End Sub