linking forms

[charityworker]

Hi All,

I wonder whether you can help. I'm new to the forum and realtively new to access and have a couple of queries - which I think are straight forward but have me baffled:

1) I've created a form with a unique auto generated record code. At the bottom I've created three buttons that link to forms that are all related to the initial form (they are effectively more details questions relating to the main form and so there will never be more than one of each per main form). What I can't do is find a way to make sure that the three 'sub' forms pull though on the same ID code, thus linking them together.

2) On a control tab I have 5 separate tabs and each one has a score in - I need these scores to show in a separate tab but all added together. Is there a simple way for this to happen?

Any help on this would be great as I've spent the last two days on these two and I'm no further forward.

Thanks so much!

D

 

[SBBJarrar]

sir,
for the ist part answer may be this work
for all three subforms in the record source use a query with subformid cretria = forms!mainform!id

and for adding new records on subform make a text box and in default value property put = forms!mainform!id with locked propery to true

it will work if the main form is open

 

[charityworker]

Thanks for this.

Can I clarify, although they are three separate forms - they are contributing to the same record. Therefore all of the fields (from the three additional forms and the main form) are coming from the same table. I just need to ensure that the data entered sits in the same table as part of the same record.

Does that make sense?