OK, so I've read http://www.vbforums.com/showthread.php?t=469872 15 times trying to find the answers. I have modified the code, and have come to the conclusion that I'm stumped.

I have a form in VB 2005 with a number of fields:

PhoneNumber
Name
Address
CustomerID
etc.

Which correspond to the fields in my backend Access 2003 Database
Cust_PhNumber
Cust_Name
Cust_Address
Cust_ID
etc.

I can do the Insert into my Database no problem. What I'm trying to do is the user will put in a CustomerID in the VB form, and the rest of the data will then populate on the form; it can either be updated, deleted, or left alone. When the user hits the save button, it will update the database acccordingly.

As I mentioned, jmcilhinney's post is really good, so I'm sure the Update portion will not be a problem (although my confidence is definitely wavering). I think a DataGrid would have been easier, but at the time I was designing the forms in Visio, it didn't make sense to have a datagrid that's going to be one row and 32 columns wide.

Any ideas?? Appreciate your suggestions...
Thanks
Chris