Thanks for the piece of code!! It works fine!!!!! BUT, before I decided to put this "Highlight" facility in users were able to click on any item in the list box and a subform would be displayed showing the full record details corresponding with their selection. Now that the List box is set to MultiSelect it breaks on the item double-click event.
The following code is behind the double click event :
Private Sub List23_DblClick(Cancel As Integer)
Me.RecordsetClone.FindFirst "[ID] = " & Me!List23.Value
Me.Bookmark = Me.RecordsetClone.Bookmark
DoCmd.OpenQuery "Open Requests, acViewNormal"
DoCmd.Close acQuery, "Open Requests"
I thought about trying to chang the MultiSelect property to 0 as the first line of the Sub but not sure how to get it working. Any advice would be greatly appreciated!!