Hello,
i am building a user creation form.
I have built it with 3 subforms
Subform 1 is voor general information about the user.
Subform 2 is some more specific information about the user
Subform 3 is more info about the same user.
Now when i create a user (record) in subform 1 it gets the primary key lets say 14. Then when i add information in subform 2 i want it to grab the Primary key 14 from subform 1. so that the information which is inputed in subform 2 wil be related to information from subform 1. i hope i am making sense. but how do i create this. i get it working if i make a Main form and then put subform 2 and 3 in a subform and then let them grab the primary key from the main form. but how does this work with 3 subforms and no mainform.
thanks in advance.
i am building a user creation form.
I have built it with 3 subforms
Subform 1 is voor general information about the user.
Subform 2 is some more specific information about the user
Subform 3 is more info about the same user.
Now when i create a user (record) in subform 1 it gets the primary key lets say 14. Then when i add information in subform 2 i want it to grab the Primary key 14 from subform 1. so that the information which is inputed in subform 2 wil be related to information from subform 1. i hope i am making sense. but how do i create this. i get it working if i make a Main form and then put subform 2 and 3 in a subform and then let them grab the primary key from the main form. but how does this work with 3 subforms and no mainform.
thanks in advance.