From the course: Access 2019: Tips, Tricks, and Techniques
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Build the combo boxes
From the course: Access 2019: Tips, Tricks, and Techniques
Build the combo boxes
- [Instructor] Using text boxes on a form for data entry will get the job done in most cases, but it's not always the best solution for some types of information. On our Enter a New Customer button when I click on that that'll open up the Customer Data Entry form. Here we have wide open text boxes that really help the end user consistently enter information that appears over and over in the database. For instance here we have the City and the State fields. By converting these text boxes into combo boxes where a limited list of options is presented you can gain better control over the data entry process and help guide the end user to making the best choice. So let's improve the functionality of this Customer Data Entry form by converting these two text boxes into combo boxes instead. To do that we first need to take a look at where this data is gonna be coming from. We have over here in the Tables group a table here called States and if I open that up we'll see we have a column for a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.