Help with subform (1 Viewer)

gar348

Registered User.
Local time
Today, 04:40
Joined
Jan 24, 2017
Messages
17
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

Well-known member
Local time
Yesterday, 23:40
Joined
Apr 9, 2015
Messages
4,337
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.
 

Users who are viewing this thread

Top Bottom