On a form, I have a subform setup as a continuous form.  The continuous
subform is displaying two fields of a five field table.  The three fields not
being displayed are parts of the key and the user does not need to see these.

The driving form builds a select for the subforms recordsource  And this
works fine.  But when the user enters additional data on the subform and the
records are inserted into the table, only the two fields on the subform
contain data.  The three key fields are blank.

I know I can update the key fields after the fact with an update statement
but, is there a way to set the key fields so when a record is inserted, all
of the fields are loaded?  I was kind of hoping the values would be picked up
off the where clause in the select but this does not seem to be the case.

Any help would be greatly appreciated.