Continuous subform inserting data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
RGillfillan said:
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.
Click to expand...

You need to set the MasterLink and ChildLink properties of the subform
control and then Access will automatcially "push" the key fields from the
parent record into any subform records you create.
 
Back
Top