Text Box value missing

[tygerwoods]

I have several textboxes on my form using a table adapter these fields are binded to the columns in my SQL server database, creating, editing, saving seems to work just fine, however, when I pull up a record already saved in my database the data shows on my form just fine, but when I try to place the value of one of my textboxes in a variable the value is nothing even though I can see the value in the textbox is there. Am I missing something? An example of what I am talking about is.



Public TriPart(3) as string

<Code>

Me.TriPart(0) = me.ridertxtbox.text.trim



The above is a sample of what I am using on my form, the TriPart array is also on my form

 

[cjard]

I have several textboxes on my form using a table adapter these fields are binded to the columns in my SQL server

Controls are never bound directly to the database. They bind to a local table, then the tableadapter keeps the db and the local table in sync.

Am I missing something?

No, what you have written seems correct. It might help to see your entire project, because youre not really pasting all, or indeed any helpful code