Adding data while keeping forms synchronized

[M G Henry]

I am having difficulty with Access 2003 staying syncronized as I move
between forms...

I have created approximately 10 different full page forms each form has
many fields that are originating in each of the 10 different tables,
and there will be four common fields between all of the tables / forms

the common fields are

document number
customer name
document name
date

I have built all the tables with all the fields for each of the forms
sucessfully, and because these pages were originally created in word, I
have cut and pasted the copy from the word documents as a background to
each form in access and populated them with fields from various
tables... so far so good....

Now I am trying to add the data, and I start with the header form that
contains the common fields, and then I want to be able to move between
header form and page 1 form, page 2 form, etc....

I have the relationships defined between the various tables related to
the various forms but cannot find a way to move easily from one form to
the next carrying over the common fields, allowing me to add the data
to the fields on the various forms and keep them all syncornized.

This is my first post to any group, and I hope that I have expalined my
situation adequately.

 

[John Vinson]

Now I am trying to add the data, and I start with the header form that
contains the common fields, and then I want to be able to move between
header form and page 1 form, page 2 form, etc....

One suggestion would be to make all of the subsidiary forms into
Subforms on your "header" form. You can use a Tab Control, and put one
form on each tab page; using the four fields as the Master/Child Link
Field will keep them in synch.

John W. Vinson[MVP]

 

[M G Henry]

One suggestion would be to make all of the subsidiary forms into
Subforms on your "header" form. You can use a Tab Control, and put one
form on each tab page; using the four fields as the Master/Child Link
Field will keep them in synch.

John W. Vinson[MVP]

I have some familiaity with the Tab Control for setting up a form, but
not sure how to set up the master / child link fields...

M G Henry

 

[John Vinson]

I have some familiaity with the Tab Control for setting up a form, but
not sure how to set up the master / child link fields...

M G Henry

The Master/Child properties apply to each subform - they have nothing
to do with the tab control, which is only a way of managing screen
real estate.

The Master Link Field and Child Link Field properties of each of the
subforms would be

[document number];[customer name];[document name];[date]

and you should probably change the fieldname Date to DocumentDate or
something else suitable; Date is a reserved word and Access *will* get
confused.

John W. Vinson[MVP]

 

[M G Henry]

I have some familiaity with the Tab Control for setting up a form, but
not sure how to set up the master / child link fields...

M G Henry

The Master/Child properties apply to each subform - they have nothing
to do with the tab control, which is only a way of managing screen
real estate.

The Master Link Field and Child Link Field properties of each of the
subforms would be

[document number];[customer name];[document name];[date]

and you should probably change the fieldname Date to DocumentDate or
something else suitable; Date is a reserved word and Access *will* get
confused.

John W. Vinson[MVP]

 

[M G Henry]

I have some familiaity with the Tab Control for setting up a form, but
not sure how to set up the master / child link fields...

M G Henry

The Master/Child properties apply to each subform - they have nothing
to do with the tab control, which is only a way of managing screen
real estate.

The Master Link Field and Child Link Field properties of each of the
subforms would be

[document number];[customer name];[document name];[date]

and you should probably change the fieldname Date to DocumentDate or
something else suitable; Date is a reserved word and Access *will* get
confused.

John W. Vinson[MVP]

Thank you for the help John,

Read up a little more on tabbed forms and it makes it much easier... I
very much appreciate your assistance...