I'm using Linked Forms, one form interacts with one table and the other linked form to another. I want to be able to assign a textbox in the secondary form to the primary key in the textbox of the primary form automatically. I figured since the forms were linked that it could be done directly but it can't, I also thought about using a global variable but I'm not too familiar with the rules of VB.
So for example, after entering the customer information on form 1, a button to open form 2 is clicked and multiple products can be added (multiple records) and I want all of them to have the primary key value of form 1 assigned to the CustomerID number next to each record.
Another thing I would like is for the multiple products to remain on the secondary form for each corresponding customer after closing it out. The records do save into the table but they don't save in the form after it's closed.