Deleting Grouped Records

[sandhurstUK]

OK, so now that I have grouped records together successfully within a qry and displayed them in datasheet format in a form (which looks superb), why is it that if I attempt to delete a grouped record from the form I get an error saying 'cannot delete record - read only' although the field properties within the form states 'Allow Deletes - Yes ????

 

[Rich_Lovina]

Sounds like you may be trying to delete from the displayed result, which is where the 'Cannot Delete' command displays for me.

This is because you are viewing and trying to take action on a grouped 'report' if you like.

If the selected 'grouped by' records are to be deleted:

Have you tried Qry - Delete, or failing that

Add a spare field to your table that the data is grouping on, then run an update query on the grouped data, and update the data to yes. (Spare field = yes/no).

Then Use delete where table.Sparefld =yes.

Hope I have understood yr question and that this helps. Good Luck

 

[sandhurstUK]

That sounds like the solution I need, I will give it a go.
Thanks

 

[sandhurstUK]

I have added a Yes/No field to my table and qry, the qry displays the field OK, however when I attempt to use it, I get a status bar error saying - This recordset is not updateable.

In other words, it won't let me check this field although if I go back to the table I can use the Yes/No box no problem on each individual record, which is understandable because this is the ungrouped base data.

If it helps, each recordset could be associated to as many as 20 or as little as one record in the table, dependant on what work needs to be done. All I am trying to achieve is a simple method of removing the grouped records once the work has been done, without having to go back to the table each time and deleting the individual components.
Perhaps even sending the deleted records to a seperate table called Work Done may be a solution, but until such time as I can perform a funtion on a recordset, I am not getting anywhere.

Any ideas ??

[This message has been edited by sandhurstUK (edited 02-15-2002).]