If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding data while keeping forms synchronized
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. |
#2
|
|||
|
|||
Adding data while keeping forms synchronized
On 3 Dec 2006 19:48:39 -0800, "M G Henry"
wrote: 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] |
#3
|
|||
|
|||
Adding data while keeping forms synchronized
John Vinson wrote: 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 |
#4
|
|||
|
|||
Adding data while keeping forms synchronized
On 4 Dec 2006 10:14:53 -0800, "M G Henry"
wrote: John Vinson wrote: 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 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] |
#5
|
|||
|
|||
Adding data while keeping forms synchronized
John Vinson wrote: On 4 Dec 2006 10:14:53 -0800, "M G Henry" wrote: John Vinson wrote: 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 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] |
#6
|
|||
|
|||
Adding data while keeping forms synchronized
John Vinson wrote: On 4 Dec 2006 10:14:53 -0800, "M G Henry" wrote: John Vinson wrote: 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 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... |
Thread Tools | |
Display Modes | |
|
|