Cannot delete records in Subform.

  • Thread starter Thread starter Bry
  • Start date Start date
B

Bry

I am unable to delete records within a subform
(continuous) when I have it open in another form. If I
open the subform on it's own, I am able to set
the 'Delete Records' property to true, and I'm able to
delete records. But when I open up the main form, with
the subform embedded, I cannot delete records (all I get
is a beep) and when I open up the form and subform in
design view, the 'Delete Records' proporty of the subform
has been set back to 'No' and even if I change it
to 'Yes' and then switch to Form view, I still cannot
delete records. And if I open up the View that the
subform is based upon, I can delete records. What is
going on?
 
What is going on?
Click to expand...

Could the two Forms both be editing the same records, the ones you're
trying to delete? If so, one form will have them locked and will
prevent the other form from deleting them.

Another possibility: if the mainform's Allow Delete property is set to
False, I belive that the subform will inherit this prohibition.
 
Back
Top