This is probably an easy question, but I wanted to know the best way to add/edit/delete records from a form. The form is based on one table, with many foreign tables linked.

There will be a listview where the user selects the record to view (primary key). Then there will be textboxes, comboboxes and listview for the resulting data. This will be view mode, then the user can edit that data via typing new info into the textboxes, selecting a different value with the combo box or selecting a different value int eh sub-listviews and save. They can also create a new record, which blanks all the controls and allows to save once new data is entered. User can also delete the data.

My question is, what is the best way to populate the controls when a record is selected in the primary list view? I used to work in access and you would just set the recordsource for the form and then the controls on the screen would be bound to that data.

I'm thinking about having add/edit/delete and then save/cancel buttons. Is there a good coding sample for this in VB2013?