O'Reilly logo

Microsoft® Access® 2010 Inside Out by Jeff Conrad and John Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Basing a Form on a Multiple-Table Query

When you bring together data from multiple tables using select queries, the result of that query is called a recordset. A recordset contains all the information you need, but it’s in the unadorned Datasheet view format. Forms enable you to present this data in a more attractive and meaningful way. In the same way that you can update data with queries, you can also update data using a form that is based on a query.

Creating a Many-to-One Form

It’s easy to design a form that allows you to view and update the data from a single table. Although you can include selected fields from related tables using a list box or a combo box, what if you want to see more information from the related tables? The best way to do ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required