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?

[zmbd]

abenitez77:
"View" tends to make me think of SQLServer or MYSQL... so I need you to clarify a few things:
Are you using just Access?
IF not then what software are you using?

[abenitez77]

I'm using ms access 2007 for front end and SQL Server 2008 for backend.

[Rabbit]

In certain situations, you can move the subquery to the where clause and that will allow you to delete from the view. But to determine that we would need to see the SQL.