Deleting data in grids (sub-forms)

in

One of Access' best features is how easy it is to add related data sets. Forms frequently have embedded sub-forms or grids. Typically there are buttons for adding or editing rows in the sub-form If there is not a specialized button on each row for removing that row, you can still easily do so as follows. In a sub-form, there is a left-most grayed column, thin and empty. This is the row selector column. If you click next to a row in this left most column, the form responds by putting a right-facing triangle in the column, indicating you have selected that row in the sub-form. Now just press delete (the Delete key on your keyboard) and you will get a message asking you to confirm deleting or removing that row.

*You can also click in the left column, the row selector column, and drag the mouse down through a bunch of rows. This will enable you to delete a series of rows just by pressing the DEL key. But if you try to delete using right-click with the mouse, you will unselect the multiple rows and just delete the row your mouse pointer sits on.

Do not click the delete button on the bottom of the form itself. That button is reserved for deleting the entire record on the screen--the main data as well as ALL the rows in the sub-form.