How to Create a Form with a Subform in Access

In this video I will explain what a Form and Subform are. I'll show you how to create a Single Master Form and a Continuous Subform to go inside it. We will track employees and their mileage reports.

Janessa from Durham, North Carolina (a Gold Member) asks: I have a business where we reimburse our employees for mileage. I've been keeping track of their miles for every day in an Excel sheet, but I know there's got to be a better way to store them in my Access employee database. Can you help me?

Members

Members will see how to determine if a specific record has already been added to a subform, and if so, don't allow it to be added again. This is handy to prevent duplicate services for the same customer, or you can use it to see if a product has already been added to an invoice. We'll design a "wizard" to enter mileage where the database will ask you the date, check to see if it's been entered, and if not, ask you for the mileage.

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

• Relationships: https://599cd.com/Relationships
• Continuous Forms: https://599cd.com/Continuous
• Blank Template: https://599cd.com/Blank
• Contact Template: https://599cd.com/Contacts
• Invoicing: https://599cd.com/Invoicing
• Vehicle Maintenance: https://599cd.com/Vehicle
• Widows & Orphans: https://599cd.com/WidowOrphan
• Subform in Continuous Form: https://599cd.com/SubformInContForm
• Nested Continuous Subforms: https://599cd.com/NestedContinuous
• Event Enrollment: https://599cd.com/EventEnrollment
• Access Expert 3: https://599cd.com/ACX3
• Side by Side Subforms: https://599cd.com/ACD21
• Composite Keys: https://599cd.com/ACX23
• Increment Quantity if On Order: https://599cd.com/ACD27
• Microsoft Subforms Help: https://tinyurl.com/y5w2uoho

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

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Create a form that contains a subform, One-to-many form, What is the subform in Access, How do you create a subform in Access, What is main form and subform in MS Access, access subform tutorial, how to create subforms, how to use subforms, create a form with subform, Creating a Subform in Microsoft Access, main form and subform in ms access, composite key