Deleting records in a subform of a subform

[Cuyler]

Using Access 2007 with Vista Premium, I have a customer master form. I have
a subform in this form which views one-to-many contracts for that customer.
Within the subform is another subform to view multiple tickets for the
particular contract.

When I highlight a record in the second subform and hit the delete key the
record appears to delete. However, no delete warning message appears and the
record is only marked for deletion in the query, but is not physically
deleted. Going to design view and back to form view confirms that the record
in the second subform was not deleted.

Highlighting a record and hitting the delete key in the first subform
actually deletes the record and all cascaded records as it should.

Both subforms are set to allow deletions is the properties and are set to
lock edited records, though I have tired it with no locks.

How do I get records in the second subform to delete? Why don't they delete
by highlighting the record and hitting the delete key?

 

[Tom van Stiphout]

On Mon, 10 Dec 2007 06:07:04 -0800, Cuyler

What is the RecoirdSource of the subsubform? My guess is that it's
some query, and that if you tried to run that query and to delete a
row from that query, it would fail as well, perhaps because of
unneeded joins with other tables.

-Tom.

 

[Cuyler]

Yes, Tom. If you run the subform that has the second subform it will fail
as well. That is the record can be deleted from the first subform with all
cascading records in the second subform. However, the record cannot be
deleted for the second subform.

The first subform is based on the Contract Master Table with links to the
Customer Master by the Customer ID Number key field. The second subform is a
query.