Delete a record within a macro

[Handford]

I am not au fait with the workings of VB and have been tasked with a very simple database - so I decided to try and use a couple of simple macros. It is mostly in place although the last thing I need to do is find some way of deleting a record in a table as part of macro. Is this possible?

I have writen a macro that finds the record that I wish to delete from the table. But just need the step to delete this record.

I would appreciate any help.

Handford

 

[PHV]

that finds the record that I wish to delete
How you did that ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Handford]

It opens up a table - then applies a filter leaving only the record I want to delete.

it was then the idea to delete this record and close the table.