Subform Foreign Key Auto Entry

[Swift_74d]

Quick question that i simply can't figure out...

I have a main form set up to allow the choice of an existing, or the entry of a new, employee from a table. This choice fills a sub form (continuous forms) with all the entries from another table. I would like to know if its possible that when the user begins to enter a new record in the subform if the foreign key can be automattically filled based on the primary key of the main form.

 

[Norie]

Set the default of the foreign key field to the value of the primary key from the main form.

You might need code for that but it's relatively straightforward.

Oh, and you migh need to add the foreign key field to the form, but you can just hide it.

 

[Swift_74d]

Thanks Norie, the simple answers, as always, are the most elusive for me.