VBA Button on Form with 3 subforms

[BAM13]

I created a form which has 3 subforms each adding a record to a different table. I have one command button which I would like to add the record to each form, ask if the user wants to add another record, if so, clear the subs and stay in the form, if not exit the form and go elsewhere. Also when you tab thru the first sub have it go to the next sub but not add the records until the command button is done. can this be done? Thanks I appreciate the help.

 

[SkipVought]

Please post MS Access questions on one of the MANY MS Access forums.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[BAM13]

it must just be me today but i couldn't find the Access forum...

 

[SkipVought]

There are at least SEVEN MS Access forums.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}