Go to record by selecting from list

[knighty03]

I would like to be able to go to a record by selecting the item from a list box without filtering the selected item.

 

[docmeizie]

Fairly simply. Make sure that the table that has the records you are looing for is bound to the form first of all. Next what you want you do is make the listbox and tie a query with just the names of the people in the list box. Next what you want to do is go to that control's After Update property and put this code in:

Me.RecordsetClone.FindFirst "[ParticipantID] = " & Me![Text89]
Me.Bookmark = Me.RecordsetClone.Bookmark

Replace ParticipantID with your own ID that will control the record set and replace text89 with the name of your listbox.

If I take a peek in your Windows, to fix a problem, does that make me a "Peeping Tom"? Hmmmmmmmmmmv

 

[knighty03]

Worked great thanks for your help.