Access 2007 Forms and Reports For Dummies by Underdahl & Darlene Underdahl

Author:Underdahl & Darlene Underdahl
Language: eng
Format: epub
Publisher: Wiley

You can add a list box to a form with a wizard or you can use Design View and build the list box yourself. The following steps show you how to add a list box to a form without using a wizard. In my example, the list box uses an existing table as the source of the values for the list box.

To add a list box to a form, follow these steps:

1. Open the Access database where you want to create the new form.

2. In the Objects list (column on left and also called Navigation Pane), click Forms.

A list of forms appears. Choose the one you will use.

3. In the Create section of the Ribbon choose Form Design.

A new, blank form opens.

4. Choose Add Existing Fields from the Design ribbon.

5. Choose the table to associate with the form from the drop-down Field List box.

In this example I selected a table called ItemsTable, which stores information about items that are consigned for auctions.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.