Subform and calculations issues

[rustyCrVx]

I have two issues that I haven't been able to resolve on a project I'm currently working on.

1) My Contact and Job subforms have malfunctioning combo boxes. They do not pull up the rest of the information on selecting a Contact or Job.



2) I can't figure out how to set up my Contact and Job subforms to save their IDs to the appropriate fields of the main form's table. I have a feeling this something simple that I'm overlooking while I feel completely brain dead atm.

3) The "Total" text box (txtTotal I believe) is supposed to show the sum of the "Amount" fields in subfDetails but no matter how I've tried I can't get this to work.

This is my first project starting from scratch so I'd appreciate any advice as well.

[RuralGuy]

SubForms are typically used to display the MANY side of a 1:M relationship. Access assists here in that the MANY side usually has a ForeignKey field that is the PrimaryKey of the MainForm RecordSource. Properly set up LinkChild/MasterFields properties will update the ForeignKey field in the SubForm when a new record is added. Your form looks very nice but you need to update the ForeignKey fields in the MainForm RecordSource with ComboBoxes on the MainForm, not the SubForms. You may also wish to rethink using cascading updates in your joins. It is usually not necessary.