Adding new recoreds with popup form

ulieq

Registered User.
Local time
Today, 08:17
Joined
Dec 15, 2011
Messages
28
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?
 
I really would like macro ONLY as its more transparent to noobs like me and coworkers.
 
clipboard01cry.jpg
clipboard01cry.jpg
This macro does to add the primary key of the parent to the child.

http://imageshack.us/f/688/clipboard01cry.jpg/
 

Users who are viewing this thread

Back
Top Bottom