Been browsing the net all night for this, and I see the idea floating around,but it's usually with ugly VBA code.
Here are the two tables. Parent: Licenses Child: Periods
Now, I can set up a button on the Parent form to open up a child form that popups using the OpenForm edit. But if I change the OpenForm to Add, the child will open up without the Parent's primary key automatically added. Even when setting a tempvar with a macro, it still wont populate. Is there a trick to this?
Here are the two tables. Parent: Licenses Child: Periods
Now, I can set up a button on the Parent form to open up a child form that popups using the OpenForm edit. But if I change the OpenForm to Add, the child will open up without the Parent's primary key automatically added. Even when setting a tempvar with a macro, it still wont populate. Is there a trick to this?