How to delete a record from table? (while subfrm linked to query)

[hjeff71]

I have a form with a subform (in Datasheet view).

The subform Record Source is a query.

If we delete a record in the subform (while in Form View), it will disappear and never be seen again in the subform (while in Form View)

However, the record is still present in the table (that the query pulls the data from)

How do you delete a record from the table of a datasheet subform that is linked to a query?

 

[jsv2002]

You would have to use a delete query. Create the query based on the table and fields you want to delete then change type to delete query "BE CAREFUL" don't double click to open or you could delete all records when used you need to specify which record to delete in much the same way as your query is filtered fo your subform at the moment.

Good luck John

 

[hjeff71]

Thanks for the reply,

Your approach is the most logical way, and it works beautifully,