Go to and highlight current record in subform

[T. McConnell]

Greetings all again,
I have a form with an unbound subform as I don't want to select just one record in my subform when I am searching.
What I have is on the form is a search record box which allows the user to type in the record and go to that record. This works fine, what I am trying to do now is when the record opens up I have one field on the mainform called CarVIN when the record pulls up, I am trying to get the corresponding CarVIN field in the subform to be highlighted and then have it go to that row in the subform, bringing attention to the one from the mainforms record. So basically search a record, when the record opens it goes to and highlghts the record in the subform.
I have seen a few different options using conditional formatting to highlight the row, which this works, but I can get the focus to go to the matching record.

Any suggestions or ideas are greatly appreciated.
Thanks

 

[pbaldy]

You can adapt the code here to use the bookmark on the subform.

http://www.baldyweb.com/Bookmark.htm

 

[June7]

I am confused. How can an unbound subform have records?

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