Access 2002 Programming by Example

Creating a List of Fields

The list boxes you have been examining have performed as pick lists. What if you wanted a pick list of fields for each table in your database? You could enumerate the fields collection in much the same way that you enumerated the tables collection. However, there is a much easier built-in technique for enumerating the fields of any table that is often overlooked. You can use the Field List row source type of a list box to list all the fields of whatever row source table is selected. You can use this option to list the fields of every table in your database at the click of a mouse button. Then simply print the form for a hard copy of your list.

Examine the following simple procedure that lists the fields of every table ...