Deleting a specific record via a macro

[Guest]

Is there a way to delete a specific record (from a table) via a macro. I
want the user to be able to delete a specific record from a table based on
entry of a primary key value. I have figured out how to delete the record
with a delete query but I can't figure out how to run the delete query from
within the macro.

Will

 

[Guest]

hi,
use the open query action.

 

[Steve Schapel]

Will,

Just to expand on Anonymous's advice to use the OpenQuery action, you
may want to preced this in your macro with a SetWarnings/No action, to
suppress the display of the action query confirmation message.

 

[Guest]

Steve,
Thanks! That's just what I needed.

Will

Will,

Just to expand on Anonymous's advice to use the OpenQuery action, you
may want to preced this in your macro with a SetWarnings/No action, to
suppress the display of the action query confirmation message.