Thank you for your example. But that is not really what i am looking for.
In the future a contract needs to contain much more data, current columns are just a start to get the function to work.
With several more columns i can not have it all in a row like your example in your extra form.

This is the process i am envisioning.
1. User opens selectprofile_frm
2. User doubleclick a row in the listbox, selecting a person/staff to view and work with.
3. When doubleclick, profile_frm opens and display the profile of clicked person/staff.
4. In profile_frm currently i am interessted to build the tab "kontrakt" where contract_tbl data will be displayed.
5. When user click on "kontrakt" tab in profile_frm i want to first see all contracts that are connected to that person. A contract can not be connected to several person/staff. A person/staff can have several contracts.
6. It is important to me to have a listbox where the user selects the contract to bring up the full contract details in several textboxes and fields below the listbox of contract´s.
This function i have gotten to work. I can click a row in the listbox and that start to populate the textboxes below in the contract_frm (subform).

Now i am stuck on creating a new contract row in the listbox and in contract_tbl.
I want to do this in the textboxes below, click a button "create new" and all the textboxes are empty and i populate them manually to create a new contract and then saves it and a new row appears in the listbox.

why the listbox in tab Kontakt?
well i do want to see how many contracts are connected to the user fast. i do not want a combobox.
the row in the listbox should only contain the essential information of a contract, not all.
selecting the row in the listbox is easy for a user to bring up the rest of the data in one fast click.



let me know if i have missed to explain anything.
thank you very much for trying to help me!!