Update and Delete Query Problem (1 Viewer)

[KW99]

Ok I have a quick question with regards to a form / query I have produced.

I have a form with search parameters on it and a requery button to search for records which subsequently appear in a nested sub form (from a query) in the form itself.

Now I have left it so that a user can amend the data from the subform and if required can use the record selector, highlight the field and delete the row.

My question is, is there a way to have a delete button for each record in the subform to save the person having to highlight the record right click and delete. I can add delete buttons for forms containing data from tables, however I am not sure if the same is true for query sub forms.

I cannot use the table data for this one as some of the headings and titles are required from other tables and inserting the data table for this one would result in a lot of numbers and jibberish without the query.

Any help would be appreciated.

Thanks in advance.

 

[KW99]

Sorted this myself thanks.

I think I was having some sort of block when trying to do this originally.

I decided to make a tabular form from the query and then insert this as the sub form. This then obviously allows you to add the delete command button to each of the records.

Job done!!