working with selected records in a datasheet

[abenitez77]

I have a SQL view linked into a ms access application. That view is used in a subform and in datasheet view. I want to select multiple records and click on a button that will delete those selected rows. I need the button because the view has 1 table and a subquery joined in the view and will not allow me to delete from the main table in that view. So, I figured I can select the rows I want to delete and then create a button that will send a passthru command to delete those records from the main table. Can you help?

 

[pr2-eugin]

How about adding a Checkbox to the Query, so that you can use that to loop through and delete?

 

[abenitez77]

Yes, that is an option I thought about, but I already have 2 other checkboxes and didn't want to have to add another if I could avoid it. I was hoping I could loop thru the selected records and send a command to sql to delete those ID's from the table in SQL.

 

[pr2-eugin]

I am If you already have the checkbox ready then what is the problem? Looping through?

 

[abenitez77]

The 2 existing checkboxes are used for something else.