orca44

I was proposing adding the item to the datatable after you had loaded it from the database, not adding it to the database itself.

Or you could try to add "Please Select" to the datatable itself.

Do you get the NullReferenceException on this line? Dim strsuburb As String = Trim(suburbc.SelectedItem("Info").ToString()) Couldn't you test whether an item was selected on the combobox before assigning to the string or before you update the existing table? If a value must be selected on the combobox before the data can be written back to the database, you could initially select the first item in each combobox.

I recreated the snippet on my side without the WebBrowser and couldn't reproduce the error. What happens if you run the code without the WebBrowser segment? Where do you dimension the tab() array?

I'm glad that you found a solution. You should also consider using the SqlDataReader for instances where you don't intend on writing any data back to the database.

Welcome to the forum. :) Since each letter should be displayed on a seperate line, there should be a .Add() call for each letter. So, you have to loop through the string from front to back, or back to front and add each letter to the listbox seperately.

The datareader class is similar to a VB6 ADODB.Recordset with the cursortype set to adOpenForwardOnly and the locktype set to adLockReadOnly. So, basically you can only loop through the records from first to last. No backwards scrolling, Find or filter is available. How many times do you perform the find or filter on the recordset? I try to use a datareader for each Find or Filter call.

You could set the Form's ControlBox property to false. That would completely remove the context menu. Is it important to still display the disabled close button? To do that you need to add this : Private Const CP_NOCLOSE_BUTTON As Integer = &H200 Protected Overrides ReadOnly Property CreateParams() As CreateParams Get Dim myCp As CreateParams = MyBase.CreateParams myCp.ClassStyle = myCp.ClassStyle Or CP_NOCLOSE_BUTTON Return myCp End Get End Property

Just to clarify : did you run the CRRedist2005_x86.msi to install the Crystal Reports runtime ?