Good day, I would ask for your help, my code below is giving me an error whether I open my new window(application/form?) resulting to appearance of the error "Object reference...." first before the said application. What is the problem in this codes? Thank you for your help. =)
Private Sub searchacquisition_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles searchacquisition.TextChanged
Try
Connect()
Dim SQL1 As String
SQL1 = "Select * from newacquisition"
FillData(SQL1)
OleA.Fill(Dset, "newacquisition")
Dim col2 As New AutoCompleteStringCollection
Dim c As New Integer
For c = 0 To Dset.Tables("newacquistion").Rows.Count - 1
col2.Add(Dset.Tables("newacquisition").Rows(c)("title").ToString())
Next
searchacquisition.AutoCompleteSource = AutoCompleteSource.CustomSource
searchacquisition.AutoCompleteCustomSource = col2
searchacquisition.AutoCompleteMode = AutoCompleteMode.Suggest
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
`