I have a database where I am trying to resolve two issues with deleting records.
The first issue is that I can’t delete a row in the subforms. The shortcut menu does not enable the “cut” option. Selecting/Highlighting the row and pressing Delete on the keyboard doesn’t work. I have to go to the table for the subform in order to delete the row. I don’t remember experienced this problem before, and don’t know the cause or how to change it.
The second solution I am seeking is to be able to use the Delete Record button to delete the main form record and the matching subform records that have the same record ID number (up to 15 subforms with multiple rows). The wizard-generated button builds a macro that deletes the main form record but not the subform records. I’m trying to find programming code that might delete everything at one time.