Hello Access Family;
HELP!...I have this problem I've been at it all last week , I have this btn on a form that takes me directly to another form i.e. =[ID]=" & Nz([ID],0) coded in macro also have it in vba code...
However when I navigate to the form ID<> ID works perfectly but when I go to the searchcombo box to choose another recorded msgbox displays "person not Found" what am I missing with the "theory of recordsets"... I want to use the searchcombo box to find a name click on a button and go directly to that record in a next Form then go directly to the searchcombo box again and pick another record=name without the msgbox displaying "person not Found" and blocking me from searching again. The code for the searchcombo box it's an After Update event listed below.
Code:Private Sub cbosearch_AfterUpdate() Dim strCriteria As String strCriteria = "[Inm_ID] =" & Nz(Me.cbosearch, 0) Me.RecordsetClone.FindFirst (strCriteria) If Me.RecordsetClone.NoMatch Then msgbox "Person not Found" Else Me.Bookmark = Me.RecordsetClone.Bookmark End If End Sub