From the course: Access 2016: Advanced Tips and Tricks

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Add edit buttons to tabular data

Add edit buttons to tabular data

From the course: Access 2016: Advanced Tips and Tricks

Start my 1-month free trial

Add edit buttons to tabular data

- [Voiceover] By viewing our tabular data thorough a split form, such as the Orders form that we just created in the last movie, we have the opportunity to provide easy access to edit data for specific records. We can do this by building a dynamic hyperlink that is connected to each and every record in this table. Let's start the process by creating a very basic form that we'll be linking to. The purpose of this form that we're about to create is to help guide our end users through the proper data entry tasks. I'll come up here to the create tab, and we'll start a new form in Design View. On the Data tab of the Property Sheet, we'll change the Record Source to the Orders table. Then, on Add Existing Fields, we'll go ahead and select all the fields here. And I'll just click in and shift click on the last one, and we'll drag and drop all of this here, into the Detail section. Then, I'm gonna make my form a little bit smaller. So, I'll come down here to the very bottom of it, and I'll…

Contents