Deleting subform record causes form record to be deleted

J

JerryD

I have two tables in a one to one relationship with Enforce Referential
Integrity NOT selected. I want to delete the subform record but not the form
record. When I attempt to delete the subform record, I get the following
message?

Relationships that specify cascading deletes are about to cause 1 record(s)
in this table and in related tables to be deleted. Are you sure you want to
delete these records?

I delete the subform record and my form record is deleted also.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy previous record into form field 0
Populate main form from subform record 0
Adding data to MS Access from csv file 0
First Subform record gets modified when closing form 3
Delete record error form / subform 1
Deleting record in subform Access 2007 - weirdness 3
Force Record in Subform 11
record selector problem 0

Top