Grab primary key and use it in subform (1 Viewer)

[Scolton]

Hello,

I am building a user creation form.
i set it up like the screen shot in the first attachement. 3 different tabs.
In tab 1 you create the user which then gets a unique key (DocentenID).
Table 2 you can input more information about the user (in a different table)
i want it to grab the primary key (DocentenID) and insert that into a field in the other table same goes for tab 3.
Has anybody got a idea how i can realise this.

thanks in advance.

 

[pbaldy]

As a general rule, if you use the master/child link properties of the subform control, Access will handle the linking field for you. Sounds like this is such a situation.