From the course: Access: VBA

Unlock the full course today

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

Allow or disallow additions, deletions, and edits

Allow or disallow additions, deletions, and edits

From the course: Access: VBA

Start my 1-month free trial

Allow or disallow additions, deletions, and edits

“

- [Instructor] When you create VBA code for a form or report, you can use the me object as a shortcut to refer to that object. If you're working with a form, for example, you can use the me keyword properties to allow or prohibit additions, edits, and deletions using that form. I'll demonstrate how to define those properties in this movie. I have opened up the course database and in the forms collection, I have opened the categories form in design view. You might see different forms based on what you've done already in the course. I want to crate an event handler for when the form is opened. So I will right-click a blank spot in the detail section and then click build event. In the choose builder dialog box, I'll click code builder, and click okay. And I get an event handler for the detail click event. That's actually not what I want. So I'll go up to the object control, click it's down arrow, and click form. Now I get a new event handler for when the form loads. On the title bar of…

Contents