C
Chris v.
Using Access 2007, I have two tables linked by the primary key "ID" in the
"Minors" table and the "minors_id" foreign key in the "Guardians" table. I
have a query for each table. the "Minors" query gets identifying data for my
Main Form, while the "guardians" query supplies the subform with its data
fields in which I need to enter new records. If I set the Main form's Allow
Additions, Allow Deletions, and Allow Edits all to NO, then when I set the
subform's properties to Allow Additions (Yes), I still have a grayed "new
record selector" and I can't add a new record? Can someone tell me what I'm
missing ... thanks.
"Minors" table and the "minors_id" foreign key in the "Guardians" table. I
have a query for each table. the "Minors" query gets identifying data for my
Main Form, while the "guardians" query supplies the subform with its data
fields in which I need to enter new records. If I set the Main form's Allow
Additions, Allow Deletions, and Allow Edits all to NO, then when I set the
subform's properties to Allow Additions (Yes), I still have a grayed "new
record selector" and I can't add a new record? Can someone tell me what I'm
missing ... thanks.