MS Access Programming Question

[spoon]

Hi, I'm not too sure where to put this post, but i since its got something related to programming, i thought i'd stick it here.

I'm doing a database in access, however, in one of my forms i wish to create a command button which would add a new record in ANOTHER table, which contains a field in the current forn.

e.g. I have form "A", entering data into table "A", which contains the field "name". I need a command button, which when clicked will create a new record in table "B" and insert the field "name" from the current record in table A to table B.

The programming is done in VB Script i think

help is much appreciated

Thanks