Copy and Pasting Values from One Form to the Next

[sevanty7]

Good Morning!

I currently have two forms both usedfor adding new records into two different tables.
The problem I am having was first that I could not simply bring the value in the ID field over from one form to the next.
Now all I would like to be able to do is copy the value in the first ID and Paste in the second ID field on the second form.
I am currently getting an error possibly because the ID field on the first form in the Primary key for the table that form is linked to, on the second form however ID field is not the Primary key, I also can't make it the primary key because their are duplicate records that I cannot delete.


So... is it possible to get around this somehow to be able to copy and paste from one form to another?

Thanks for any help!

[Dal Jeanis]

As i understand your issue -
1) Form 1 has a table/query behind it with a primary key called ID.
2) In Form 2, you are attempting to copy the ID field from Form 1 as a foreign key in a different file,
into an indexed field where dups should be allowed.
3) It throws an error when you try this.

If the above is true, then first, check to make sure that in the second table that you have set the FK field to "indexed, dups allowed". If that fixes it, please mark the thread solved.

If not, then please post the specific error message, and indicate step-by-step what you do to get that message.

[sevanty7]

Solved! Not sure how to mark thread as solved though