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.

Discover a record source

Discover a record source

From the course: Access: VBA

Start my 1-month free trial

Discover a record source

“

- [Instructor] Forms and Reports displays the contents of a record source. That is, a table or a query. If you display a form or report, and its contents aren't what you expect to see, you should check which record source it's drawing its values from. In this movie, I will show you how to use VBA to display the name of the database object from which a form or report derives its values. I have opened the course database and displayed Products form in form view. If I want to display the source of Product's data, then I can create a code module attached to this form. To do that, I will switch to design view. So I'll right-click the Products forms tab and click design view. Then I'll right-click a blank spot in the detail section of the form, and click build event. In the Choose Builder dialog box, I'll click code builder, and then click ok. And I will drag my code window to the top left. I currently have the details section being clicked as the event that I want the code to run on. I…

Contents