access 2007 subform update problem

[sd0t1]

I'm trying to create a form that enters evidence for trials. it's a form on top and a datasheet subform on bottom. I have created 2 queries to tie in all the data fields from 4 tables that have all necessary info.
Case Query contains fields from CASE and DEFENDANT tables, Summary Query contains fields from EVIDENCE and SUMMARY tables.

Tables
CASE - case_id, case_no, division...
DEFENDANT - def_id, f_name, l_name, oca,...

EVIDENCE - evidence_id, evidence_name, evidence_desc...
SUMMARY - summary_id, case_id, def_id, evidence_id...

I want the user to enter case information and defendant information at the top of the form (once). Then enter multiple pieces of evidence at the bottom of the form in a datasheet.
Each piece of evidence entered in the subform datasheet should recieve the case_id and def_id from the top part of the form.
Ok, the problem is, for whatever reason the def_id makes a new row in the database with just the def_id everything else is blank. Then each subsuquent rows have all the correct data except no def_id.

Any ideas anyone?
Did I provide enough info?

 

[dhookom]

Set the Link Master/Child properties so the Case_ID and Def_ID values are synched to the subform.

Duane
Hook'D on Access
MS Access MVP

 

[sd0t1]

I'm very new to Access 2007, can you tell me how to set the link master/child properties to both sync to the subform.

I really appreciate your help.

 

[sd0t1]

Hey I found a great tutorial that discussed this subject and it helped me figure out the rest.

Thanks for putting my on the right track.