From the course: Microsoft Access: Forms and Reports

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Embed a subform control

Embed a subform control

From the course: Microsoft Access: Forms and Reports

Start my 1-month free trial Buy for my team

Embed a subform control

“

- [Instructor] Sub-form controls allow you to create linked table like displays of information that are related to a main topic. We saw an example of a sub-form briefly in the beginning of this course when we used the form wizard to display a list of all of the orders that included a specific product. Let's now duplicate that functionality ourselves using the sub-form control. I'm going to create a brand new form in design view. This form is going to be a form that displays information about our products, so the very first thing we need to do is to connect it to its data source. We can do that by opening up the property sheet and going to the data tab for the form, find the record source property, and using the dropdown menu, I'll connect it to the products table. Then we can add in a couple of fields using the ad existing fields panel. I'll drag in the product number, the product name, category and price fields.…

Contents