[2005] VB - Pass Selected ListView Item To Another Form

[nolim8ts]

Hi All,

I have a listview which is populated via SQL. When I select the Item index, I was to open a form which will populate from SQL based on the selected item index.

e.g

Dim SQLSelect As String = "SELECT * FROM tblSuppliers WHERE [Supplier Code] = '" + lvwSuppliers.Items(lvwSuppliers.FocusedItem.Index).SubItems(0).Text + "' "

Any suggestions?