Good morning doogle,
I am attempting to take the listview items that were loaded, like in these examples (there are more, just wanted to provide a smaller example):
And place them in textboxes or combo boxes. The user will select the row, and click a command button that runs the below.Code:lvwItem.SubItems(1) = oRS.Fields.Item("Loan_Number").Value & "" lvwItem.SubItems(2) = oRS.Fields.Item("Investor").Value & "" lvwItem.SubItems(3) = oRS.Fields.Item("State").Value & "" lvwItem.SubItems(4) = oRS.Fields.Item("Doc_Type").Value & ""
I am using the belowHowever if the combo boxes (cbo) are set to 2-Drop down list, AND the field is blank on the database, i receive the read only error. However If i change it to 0-drop down combo. I would like to keep it as 2-drop down list and create a workaround if blank. But if that's not possible i understand.Code:Private Sub cmdSelect_Click() txtLoanNumber.Text = ListView1.SelectedItem.SubItems(1) cboInvestor.Text = ListView1.SelectedItem.SubItems(2) cboState.Text = ListView1.SelectedItem.SubItems(3) cboDocType.Text = ListView1.SelectedItem.SubItems(4) end sub
I attempted the above and I still receive the same error.
Thoughts?




Reply With Quote