add/edit/delete data to tables in Access

I am new to VB and I am trying to develop a small application in Access. I have 5 tables, each has an id and a name field. The tables are joined with one another by the id field. The id field in each table is an "autonumber".
I want to get the name in each table from the user through a text box in the form and append the record to the respective table. How should I do this? I have been reading several books on VB but I have not been able to figure this out.

I would appreciate if someone could give me the code to do this? I also want to do additional functionality to edit or delete records from these tables. Thanks.

Do a search here on 'ADO' and I'm sure you'll find what you are looking for [I know I did when I had the same question].

And Doof, you had a bunch of us telling you to do a search too ...:D I guess we're getting old now ...