The Lists Tab allows you to create drop-down menus for lists of items you need to enter repetitively (i.e. stud sizes).

Create a New List

• Select the New list button
• Select the type of list
  • Simple List - You input the list option
  • List from MS Access File Tables - List choices come from a Microsoft Access database
  • ADO Query List - List choices come from a query list
• Select Next to continue

Simple List

• Enter the Name for the List, this is the name you will use in item Properties
• Click Next to continue

• Enter the values you want in the drop-down list. Your list will be saved and available to you when you are done entering choices. If you are using formulas, you must check the Parse Formulas box as in the second image.

MS Access File Table

• Enter or navigate to the file containing the database
• Click Next to continue. All the tables from the database are made into Lists and the values in those tables added as list entries

ADO Query List

• Enter the name you want to use to reference this database, this is the name you will use in Properties later.
• Enter the Connection String and SQL.
• Click the Next button to complete the database connection.

Exploring the Lists Tab

Lists - Properties

Related Articles