OLEDBADAPTER1.FILL () doesn't update text fields in tab controls?? why is this?

[cgchris99]

I have a lookup form that calls oledbadapter1.fill(form1.instance.objdataset1,"filename")

This works fine for any field on form1 that is on a displayed tab. However, any data bound field that is displayed on a tab that is not currently active does not update until you click to activate the tab itself.

I know this because I have another button that sends this data out via telnet and during the debugging process, I verify I am sending the correct fields and correct data. The contents of the text boxes will be empty until you click on the tab that has these fields.

As long as you click on each of the tabs after the ".fill" command then all the textboxes update and are filled correctly.

I have tried form1.refresh form1.validate etc.

Thanks for any help you can give on this problem.

 

[Robby]

Im not sure I understand your question. But I think it may have to do with the fact that a Dataset is disonnected from the DB.

 

[cgchris99]

I dont know how else to explain it. The fill works fine on any textbox that is currently visable (not the property visable) on the form. If the field is in a tab that is not the current active tab, then the textbox field does not update until you select the tab that this field is on.

Lets try this.
You have a form it has one field on it called TextBox1. You have two tab pages called tabpage1, tabpage2. On tabpage1 you have Textbox2 & TextBox3, on tabpage2 you have TextBox10, TextBox 11, Textbox12.

No you the fill happens TextBox1, Textbox2, & Textbox3 will all get updated with the Data from the Fill command. However, if you do not select TabPage2, Textbox10, 11, & 12 will not get the data. The minute you click TabPage2, Textbox10, 11 & 12 will then get loaded with the correct data.

At first glance, youd think this is no big deal. But it is when I am trying to send this data out over telnet and have not viewed each individual tab after the fill happens. Then Textbox10, 11, & 12 are empty or have the old data in them.

Thanks for any further help