I have a form with a datagrid that has a list of bank accounts. I want to be able to open monthly statements when I double-click the grid. The only thing I need is for the user to pick the month they want to open. I was hoping to bring up a listbox with the 12 months, and when the user selects the month, I want to be able to identify what month they selected.
Private Sub TblTBDataGridView_CellContentDoubleClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles TblTBDataGridView.CellContentDoubleClick
Dim AcctNum As String = TblTBDataGridView.Rows(e.RowIndex).Cells(2).Value
Dim BankName As String = TblTBDataGridView.Rows(e.RowIndex).Cells(1).Value
Dim SMonth 'this is what I need to get from user
'This is where I need to prompt the user to select the month
Process.Start("Y:\Documents\Statements\" & BankName & "\" & SMonth & "\" & AcctNum & ".pdf")
ErrMessage = MsgBox("Document not found!", MsgBoxStyle.OkOnly, "Error")