Please Help - problem with adding new records to Subform

[mrl]

I have a db with a main form containing a subform that is linked using the master/child fields control.
The main form recordsource is a Department table.


The Department record is selected using a combo box.
The related fields are the ID in the Depts table and the Dept ID in the course table.
The subform is based on a query that displays the related records for the selected Dept
(ie one Dept runs many courses).
The records in the subform can be edited/added, however when I add a new
course record in the sub form I have to manually select the Dept ID.
Is it possible to have the Dept ID for the new record to automatically link/lookup
the selected/related Department from the Parent form (ie; if the Legal Dept has been
selected in the main form then the new course record should be automatically be for the Legal dept).

[orange]

There's a free video tutorial here
http://www.youtube.com/watch?v=YZKN_-P6wck

see if that clears things up.