I have a form, data table, and MS Database all tied together and working fine (using Bindingsource, table adaptor, currency manager, etc.). When the form fields are changed, the table is updated and then the database is updated. This works great.

What I would like to do is write directly to the table and not have to create a form textbox and bind it to a table field. Can someone provide an example of how to update data in an existing record in an existing table using only VB code? I am using VB2005.

Thanks in advance for your help.