Art had posted a screen shot in our help needed files. It showed buttons on the subform detail section. I think there is something else going on. If he uploaded at least a stripped down version of the file we would be in a better position to help.
Duane
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, April 23, 2018 4:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Cannot delete a record in a subform
Sent: Monday, April 23, 2018 4:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Cannot delete a record in a subform
Art - did you see my question as to the placement of the button. Since the sub form is a continuous form I'm betting the button is on the main form. Your code is trying to delete a record on the main form. As long as you do not have cascading delete enabled you should get that error message. That's a good thing because you should not be deleting parent records as long as child records exist.
But that safety net is not the problem you need to fix. You must re-write your code so the sub form record is the target.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <dbalorenzini@yahoo.com> wrote :
The main form or the subform?
THe subform allows deletions, edits and filters but not additions
The main form allows deletions, edits and filters and additions
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (14) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar