Find record based on text box

[June7]

Well, I am not have luck capturing RecordsetClone object of NavigationForm subform. I find this form structure very frustrating. https://www.accessforums.net/forms/t...orm-32053.html



Made one more attempt. This works:

Private Sub Combo11_AfterUpdate()
With Me.NavigationSubform.Form.RecordsetClone
   .FindFirst "[ID]= " & Me.Combo11
If Not .NoMatch Then Me.NavigationSubform.Form.Bookmark = .Bookmark
End With
End Sub

[tazzzz]

June7
Thank you for the code. Is working really nice for the db provided to you.
I created a couple of more tabs to try it as for my real db. There are still a couple of questions:
- what should I change in the code to use it for[JOBNUMBER] INSTEAD OF [ID];
-also, the combo will bring data only for active tab and not for the other tabs(I have to re-select the combo every time I activate a tab)
Once again, thank you for the code.

[June7]

Why would you need to change the code? User selects JOBNUMBER but the code uses the ID.

However:

.FindFirst "[JOBNUMBER]='" & Me.Combo11.Column(1) & "'"

[tazzzz]

This works !!!
What about bringing data for all the tabs?(active and non active). I tried refresh but is not working.
Thanks

[June7]

As I understand Navigation Form, only one subform is available at a time. When you click a 'tab', the subform container loads the requisite form. I am guessing would have to run the find record code after form is loaded.

[tazzzz]

Ok, thanks for the help.