I have two forms. The first form is a search form. After the user performs the search, a list of values appears in a list box.

When the user double clicks one of the values, the second form opens with particular details of that value.

my problem: if more than one value was returned in the list box, when the user double-clicks, the first value appears in the second form. To clarify: if the user chooses the third item in the list box when he/she double clicks the first item appears in the Record Info form, not the third.

Yes, the user can move the record selector buttons but I was asked to at least make the particular value appear upon double clicking it.

Can anyone help? Perhaps a bit of code is needed?

Thanks,
Leslie

Make sure the MultiSelect property of the list box is set to None.

It is... still have the problem!

Thanks anyway though!

If the MultiSelect property is set to None, how can the list box be returning more than one item? Also, how are you opening the second form - is there something in that code or action that somehow points the second form to a previously selected item in the listbox rather than the currently selected one?

I found the problem ... was

DoCmd.OpenForm "frmRecordInfo", , , "[fileName] = '" & Me.lstsearch.Column(1) & "'"

I needed a filter on opening the form!