Gaaaah! Cannot delete records

[TooGoon]

'sup

I have a subform which calls a query, which contains to queries tied together by a relationship.

Very simple. Very common.

BUT, I cannot delete any records in it. The query tells me it is read only. But it is a dynaset, no controls are locked, referential integrity has cascade delete on, deletions are enabled on both sub and master forms. Nothing I can think of should be locking these records.

Any ideas?

 

[PHV]

In the access help take a look at updatable query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244