Updating a Table

[MDDDS]

I have 3 forms tied to 3 tables that are all used to complete a report. I type the last name on the first form and use it on the 2nd and 3rd forms to tie the forms together. I take the name typed in the first form and use it for the default value in the 2nd and 3rd form. I use the corresponding table as the control source for the default value typed in the first form. The value will not be saved in the table when I close the form unless I type it in the second and 3rd form or copy and paste it in these forms. Any suggestions as to how to get the default value to go into the table? Thanks-MDDDS

 

[theprez]

It sounds to me that the 2nd and 3rd forms should really be sub forms of form1 and linked. Once they are sub forms, you can refer back to the name on the main form (form 1) as the default.

 

[dcx693]

I agree, this set up sounds rather too complex unless you have a specific need in mind. It sounds like all this data is related. Either use a query to get all the data into one form, or use a form/subform design as theprez suggested.

 

[MDDDS]

updating table

Thanks for the advice. I usually don't use subforms, because it was easier to use separte pages(forms) for each table, but I will give it a try. Thanks for the advice.