Adding Clickable Buttons to Reports to Edit Records

In this Microsoft Access tutorial, I'm going to teach you how to put a button on a report. While it might seem like you should never need to do this, it has some surprisingly good uses. We'll use that button to open a form to go to the related record for the data shown on the report. I'll also show you how to use a hyperlink with an event instead of a button.

Noah from White Plains, New York (a Platinum Member) asks: I love the trick you showed in the Embedded Report video to display contacts on the customer form using a report instead of a subform, because it displays long contact notes and I can just read everything on the screen at once. Is there a way to make it so you can just click on the record there in the report to edit it, instead of having to switch to a data entry mode?

Prerequisites

• Embedded Report
• Intro to VBA

Links

• Internal Field List
• Transparent Buttons

Up Next...

• Buttons On Reports, Part 2

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Adding Clickable Buttons to Reports, Button on Report, Open Form, Hyperlink with Event, Docmd.openform, Can't find the field referred to in your expression, transparent button, detail section on click event, hyperlink finger