Dynamic Forms: Big Buttons for Data Entry in Access

In this Microsoft Access tutorial, I will show you how to create dynamic forms with big buttons for data entry, replacing cascading combo and list boxes. We will also explore utilizing VBA code to enable button controls on the fly, ideal for touchscreen applications in environments like greasy workshops.

Adam from Fort Dodge, Iowa (a Platinum Member, Moderator, Badge Geek) asks: Have you covered creating button controls on the fly anywhere? Can Access even do that? I need to select the year, make, and model of a vehicle. I agree cascading combo boxes or list boxes would be so much simpler, but for the people that would be using this with tablets and touch screens, they are not as friendly as buttons I've found. Especially covered in grease. LOL.

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

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!

Prerequisites

• Intro to VBA
• Vehicle Maintenance
• Cascading Combo Boxes
• Custom MsgBox
• TempVars

Links

• AutoNumbers
• Nested Subforms
• Synchronize Subforms

Recommended Courses

• Access Developer Courses

Up Next

• Big Button Form, Part 2

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

TechHelp Access, Dynamic form buttons, Microsoft Access big buttons, replace combo boxes, VBA dynamic form, cascading list boxes, touch screen data entry Access, vehicle data entry Access, grease-friendly buttons Access, Access form automation, programming forms VBA Access, creating button controls Access, TechHelp free database.