object reference

[dennishea]

This is my code

Sub Table1_SelectionChanged (ColName, Row)
a = Row
textbox1.Text = table1.Cell("Internal",a)
textbox6.Text = table1.Cell("CldOd",a)
textbox2.Text = table1.Cell("CldFrPos",a)
textbox7.Text = table1.Cell("HtOd",a)
textbox3.Text = table1.Cell("HtFPos",a)
textbox8.Text = table1.Cell("AmtWire",a)
textbox4.Text = table1.Cell("Pph",a)
textbox9.Text = table1.Cell("WrSize",a)
textbox5.Text = table1.Cell("CycTime",a)
textbox10.Text = table1.Cell("Mach",a)
Form2.Show
form2.Refresh
End Sub

textbox10.text dumps an error code of object reference not set to an instance of an object.

If I remark it out the sub works fine. :sign0148:

dennishea

 

[Erel]

I don't think that this is the problem here, but you should avoid showing a new form in the Table_SelectionChanged event. At the end of this event the focus returns to the table.
Does TextBox10 exist?

 

[dennishea]

@ Erel

yes textbox10 does exist

 

[Erel]

Please send me the code (or upload it here if you like) and I would check it.
[email protected]

 

[dennishea]

Erel here is the code and a text file for it to load.

 

[Erel]

There is no Mach column in your CSV file.

 

[dennishea]

Thanks Erel

I thought this text file worked under version 4 and was at a loss when it didn't with 5.50. I can see I have some learning to do. In the end I want to load it into a sqlite db, that will be a whole new can of worms. Thanks again for your fast response and you have created a nice product.

dennishea :sign0060: