copy data between forms

[Ela]

Hi!

I have the following problem.

I have a main form with two comboboxes.
The first combobox shows all "PI person".
The second combobox shows all "Contact person". Both are runing on queries.

A the same main form I have two buttons, which opens the subform "PI person" or "Contact person" respectively, so I can edit information about each person.

I would like to have a 'copy' button. After clicking on the button, it will copy the name from 'PI person' table to the "Contact person" table in case they are the same.

Can anyone point on the right direction how to solve this.

Thanks in advance,
E.

 

[Jack Cowley]

Create an Append query and run it with your command button.

 

[Ela]

Hi Jack!

Thank you for advice, but could you explain it to me in more details.

I have made an append query and run it with the button, but how to set a criteria to append only one record from "PI person" table (selected from the first combobox) to "Contact person" table. How to make appear the copied name not only on the dorp down of the combobox , but also in the selected text part of the combo box.

Thanks,
E.

 

[Ela]

Hello!

Thank you Pat. I will redesign the DB.
E.