oy...a list box question

[LeslieB]

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

 

[AlanS]

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

 

[LeslieB]

It is... still have the problem!

Thanks anyway though!

 

[AlanS]

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?

 

[LeslieB]

I found the problem ... was

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

I needed a filter on opening the form!