need to execute logic into vba code

[Bilal]

i understand what i am going to do and how i want to do it but i still can not get my head around vba syntax.
i got an unbound form that also has a subform.
i got an add,delete, save, and cancel button (cancel doesnt work yet, need to make it go 'inMode' normal somehow)
in the main form is the supplier data, organization, state and supplier name, when i press add i need this data to save in tblsupplier.
in the subform i got data such as first name, last name, address, postcode etc, when i save this i need it to save to tblPerson, both tables of record link with each other through the PersonID field, however i dont want any users to be able to enter either supplierID or PersonID on the form, i want it to be hidden fields and also when adding a record it should automatically move to the next record and fill that in.
if someone could please walk me through this all it would be highly appreciated

 

[Rx_]

Suggestion:
http://www.access-programmers.co.uk/forums/showthread.php?t=101099
here is a subform tutorial. Search the Sample Databases for more examples.
I did this years ago with some of the sample databases found here. It is a great introduction or in my case a great memory refreshment.