Hey Tech Friends,
its been a while since my last post trust everyone is ok...I have this MainForm with a drop down combo box with names from my db when a name is click on the record info pulls up.. however the sub form in tab control pulls up the information that will display from a junction table so it is in datasheet view and not continuous form view. when i use the combo box and search for a name it will automatically pull names to search exg typing a...b... c..etc. But when a name is not found and i press enter i get an error in the code and not Msgbox saying "person not found" I cant seem to find where my mistake is any suggestions???? want to be able to search in combo box but not necessarily filter the subforms in TabControl.. jus wanted a message person not found and later learn how to ask do u want to add person
MyCode:
Private Sub cbosearch_AfterUpdate()
Dim rst As Recordset
Dim strCriteria As String
strCriteria = "[Inm_ID] =" & Me.cbosearch
Me.RecordsetClone.FindFirst (strCriteria)
If Me.RecordsetClone.NoMatch Then
MsgBox "Person not Found"
Else
Me.Bookmark = Me.RecordsetClone.Bookmark
End If
End Sub
keep getting a debug on this line of code error.."3077"Me.RecordsetClone.FindFirst (strCriteria)