macro to delete a row from a table?

[kvanish]

I need to know how the create a macro to delete a row from a table. example.
I have a record displayed in a form. The macro should delete the record
displayed at a click of a botton. Help!!

Thank You,

 

[DaveFromDover]

You might try creating a command button and use the wizard to select the
Delete Record type. It's under record operations in the first menu. The
select the icon and name the control and you're done!

This process actually writes VBA code to accomplish your delete but the code
is pretty good in this case. Other options in the wizard write less good
code. The duplicate record comes to mind.

Hope this helps
Dave

 

[Steve Schapel]

Kvanish,

Make a macro with the RunCommand/DeleteRecord action.