Identical record in a Listbox

[mar_t]

I have a form with a listbox (lstStaff) which contains staff names and a textbox (txtSearch) for searching. Using my txtSearch box, I was able to filter 2 records with identical Family names. I double click the first item in my listbox and it opens my form (frmStaff) with all the informations for that staff--OK, but when I double click the second item still displays informations from the first item.


Help...

[orange]

What exactly is the RowSource of the ListBox?

Can you show us the code for your txtSearch box Events?

[mar_t]

Code for my txtSearch:

Private Sub txtSearch_Change()
Me.lstStaff.Requery
Me.Refresh
Me.txtSearch.SelStart = Me.txtSearch.SelLength
End Sub

my Listbox RowSource:

SELECT tblStaff.LastName, tblStaff.FirstName, tblStaff.Number, tblStaff.Unit FROM tblStaff WHERE (((tblStaff.LastName) Like Forms!frmStaff!txtSearch & "*"));

[June7]

Show the RecordSource the form is based on and the code that you use to filter the records. Need to refer to the unique staff Number field from the listbox item.

Instead of a textbox and listbox, suggest a combobox with a RowSource of:
SELECT [Number], LastName & ", " & FirstName As StaffName;

[orange]

Code for my txtSearch:

Private Sub txtSearch_Change()
Me.lstStaff.Requery
Me.Refresh
Me.txtSearch.SelStart = Me.txtSearch.SelLength
End Sub

my Listbox RowSource:

SELECT tblStaff.LastName, tblStaff.FirstName, tblStaff.Number, tblStaff.Unit FROM tblStaff WHERE (((tblStaff.LastName) Like Forms!frmStaff!txtSearch & "*"));

I've made a small mock up of your situation. Hopefully it shows the concepts.
You didn't show code for the DoubleClick event for an item in the Listbox.
I wasn't sure of the name of your form with txtSearch and LstStaff, but I have 2 forms; frmStaff and frmStaffDetails.

Post with questions as necessary.
Good luck.