Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


When I try to run DoCmd.RunCommand acCmdDeleteRecord from a Shortcut Menu on a subform I'm getting an Error Message

Posted on 2005-03-27
Medium Priority
Last Modified: 2012-05-05
that says, "can't perform DeleteRecord at this time..."  Why not?


What is the method for deleting the current record on a form using Recordset Method?
Question by:MitchellVII
LVL 41

Accepted Solution

shanesuebsahakarn earned 1000 total points
ID: 13640038
There are a number of different methods, but most other ones involve requerying the form. Are you able to manually delete the record by selecting it and then deleting, and does the code work in a command button on the form?

Author Comment

ID: 13640588
duh, had form set to not accept deletes - wow, dumb, lol.


Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question