Command Button In Access New recod In All Forms

[Guest]

HI,

I have a main form with 4 subforms in it, the main Form deals with Staff
details and The Subforms with various skills etc,

What I want to do is Click A Button Called Insert new record (Or Similar)
and have all the records in the form/subforms move on to show a new entry...

Ie Main Form shows record 1, all subforms show record 1, click new record
etc and all forms show record 2,
The subforms are actually forms based around the tables they represent, ie
Courses and have been draged and dropped onto the main form,

I jus want to be sure that when I enter data into the records that all are
the same record number...

Regards In Advance

john

 

[Guest]

Set the Link Master Fields property to the field name(s) that contains the
data common to each of the sub forms. Set the Link Child Fields property to
the field name(s) that contains the data common to the field(s) in the Link
Master Fields property.

These are properties of the sub forms. Repeat this for each of the sub forms.

Now when you create a new record in the main form it is propagated to all
the sub forms and if you select different record in the main form the sub
forms will automatically show the related records.