What I think you are trying to do is display data from multiple tables and delete the selected records from one table...
If you link a View into Access as a table and used the Access Linked table, you can do anything that the Access User Interface can do so long as the view is updatable... If this is the case, you should be able to select the records and simply press the delete key but you might get more than just one table that way.
You can create code to delete one or more records in a table but you'd need something like a list of key values... In your scenario I'm thinking you'd get the list from a multi-select list box. There are lots of examples floating around and I have rarely used it so I can't quickly give an example.
Then you'd either use an ADO command object or SQL Pass through Query (whose SQL property you'd set using DAO) to execute SQL code to delete records with a where clause using in and the value list...
Besides tables and views another thing you might find of interest in SQL Books On Line is "In-line User Defined Function", back when I played with an ADP someone told me those are updateable which I needed as you can pass parameters to it.