Deleting Records using a form & Sub form

[mattP]

This may be a real easy one to fix but I'm stumped, I have a DB that tracks and records escalations I am dealing with. Within the main review form there is a subform that is used to enter a new update, this is stored in a seperate, linked, table "tblEscJournal".

If I try to delete the main record (using the standard delete record function button) then it come up with the following error message.

" The table "tblEscjournal" is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically".

I assume this is because the sub form is open in my main form ?
Any help would be greatly appreciated

 

[maxmangion]

if you would like to delete all the records in the subform as well (which makes sense, so that you don't leave any orphan records), search this forums for "referential integrity".

 

[mattP]

Ok thanks, I'll have a look through and see what I can find.

 

[mattP]

Thanks for the very quick response, I found some threads and have had a good read through and now have it all working.

Many thanks for your help

 

[maxmangion]

you're welcome