Just a quick question I hope. I am using this simple VB code (see attached) on a button to allow edits to a form. Problem is, clicking the button only allows edits to the form not the subform. How do I modify the code to allow edits to both please?
Allow Edits on Subform
Novice
Windows 7 64bit 
Access 2007
Just a quick question I hope. I am using this simple VB code (see attached) on a button to allow edits to a form. Problem is, clicking the button only allows edits to the form not the subform. How do I modify the code to allow edits to both please?
Administrator
Windows 7 64bit Access 2010 32bit
Maybe this link will help: http://access.mvps.org/access/forms/frm0031.htm
Novice
Windows 7 64bit Access 2007
I have seen that table. Unfortunately, I am a beginner and have no idea what any of that means! Can you be more specific please? Thanks.
Administrator
Windows 7 64bit Access 2010 32bit
Me.SubFormControlName.FORM.AllowEdits = True
...using *your* SubFormControlName of course.
Novice
Windows 7 64bit Access 2007
Thanks for the help Rural Guy. Worked a treat!
Administrator
Windows 7 64bit Access 2010 32bit
Excellent! Thanks for posting back with your success.
Deletions vs. Edits
Posting Permissions
Reply With Quote