Help with subform

[gar348]

Hello.......

Hope someone can help me out - I have a database form with tab controls and various subforms all linked with child / master fields.

When a new record is added in the main form the id in 1 of the subforms remains at (new) until data is added. How can I get this to generate a ID number as soon as a new ID is given on the main form ?

 

[Ranman256]

You must save the main form record first before you can add sub records.
The SubForm must be linked to the main form via the properties :
LINK MASTER FIELD
LINK CHILD FIELD

Then IDs are auto inserted in sub records.