Update tables from an unbound form

[Duncan]

I have a form that takes input from a user, validates it then updates 2 tables and writes new data to another. I get the impression i will need 2 update and 1 insert commands in SQL however my access help file has died and my only access book only covers selecting and joining

The data validation is run through VBA when the user clicks a button and I have all of the data I need to post to the following tables ready

1) Update table 1, col3 & col
2) Update table 2, col3 & col
3) Add new record to table 3, col1, col2, col

Basically i need the syntax required in either sql or vba to do this

Thanks