Open a Form depending on Selection off List Box

[Hiten]

Hi

I have a form, with 2 Combo Box's and a List Box. The Combo Box's provide a search criteria and the results are displayed in the list box [searchList].

I want to be able to double click a record in this List box [searchList] and that will open a from [frm_SearchDisplay] with the selected record from that List Box [searchList]

Can someone please point me in the right direction.

Thanks in Advance

H

 

[clerics]

make a query or SQL code or anything you like that can show info where Table.infoID = Listbox.infoID then type this code in Double_click Event
Me.Listbox.RowSource = "Query 's name" //(or SQL code)
Remember that set your number of Listbox's column again (example Me.Listbox.ColumnCount = 5 )
Goodluck

 

[Hiten]

Thanks

Thank you for that, think I am there, but when I double click a record in that list box, how does it open the form with the record i double clicked?