Search Box in Tabbed Sheet not working

[Greycom4]

I have a simple text box in a 'Tabbed Form' that I would like to use to search on a single field and show all the data from the related record. The code is assigned to the 'AfterUpdate Event'


If I add the search box to the original form it works perfectly, however when I operate the search in the tabbed form it cant find any matches.
Is there something I need to do when working with tabbed froms ?

Private Sub Text85_AfterUpdate()
If (Text85 & vbNullString) = vbNullString Then Exit Sub
    Dim rs As DAO.Recordset
    Set rs = Me.RecordsetClone
    rs.FindFirst "[ID]=" & Text85
    If rs.NoMatch Then
        MsgBox "Sorry, no such record '" & Text85 & "' was found.", _
               vbOKOnly + vbInformation
    Else
        Me.Recordset.Bookmark = rs.Bookmark
    End If
    rs.Close
    Text85 = Null
End Sub

[June7]

What do you mean by 'tabbed form' - a tab control? Is this a form/subform arrangement?

[Greycom4]

Yes, that's correct. I have a number of Tab Controls which hold forms from the database. This particular one is a form/subform and the text box is in the Main form, thanks.

[June7]

The textbox is on main form and you want to search the main form records?

The subforms are synchronized with main form through Master/Child links properties?

[Greycom4]

Yes, absolutely correct on both points.

[June7]

Try:

Me.Bookmark = rs.Bookmark

It isn't really necessary to set a recordset object.

Private Sub Text85_AfterUpdate()
If (Text85 & vbNullString) = vbNullString Then Exit Sub
    With Me.RecordsetClone
    .FindFirst "[ID]=" & Text85
    If .NoMatch Then
        MsgBox "Sorry, no such record '" & Text85 & "' was found.", _
               vbOKOnly + vbInformation
    Else
        Me.Bookmark = .Bookmark
    End If
    End With
    Text85 = Null
End Sub

[Greycom4]

Thanks June7 for your assistance.
I have tried your suggestion but still get the same result, which was the message box saying no such record found !!

[June7]

Is ID a number field?

If you want to provide db for analysis, follow instructions at bottom of my post.

[Greycom4]

Yes, ID is a number field. Providing a copy of the db will take some effort to desensitize, can I provide a more detailed description of the form ?

[June7]

If you want, will try to understand.

I don't see anything else wrong with the code. The method works for me.

Text85 is UNBOUND?

[Greycom4]

June7, I created a completely new set of tab controls and the search function worked perfectly. In my original tab control the first tab had some objects (buttons) that were setup to run code such as importing data. I think this is where the problem was coming from. Are you aware if it is possibe to have your first tab dedicated to running code and macros from buttons and then the remaining tabs to showing forms ?
I would be interested in you input. Anyhow, thanks for your assistance and very prompt respone. Regards Greycom4