• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Building a Form > Simplifying Data Input with a Form

Simplifying Data Input with a Form

One drawback to working with a relational database is that often you have to deal with information stored in multiple tables. That’s not a problem if you’re using a query to link data, but working with multiple tables can be confusing if you’re entering new data. Microsoft Access provides some great ways to show information from related tables, thus making data input much simpler.

Taking Advantage of Combo Boxes and List Boxes

In Chapter 10, “Using Forms,” you saw how you can use a combo box or a list box to present a list of potential values for a control. To create the list, you can type the values in the Row Source property box of the control. You can also specify a table or a query as the source of the values in the list. Access displays the currently selected value in the text box portion of the combo box or as a highlighted selection in the list.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint