Special Edition Using Access 97, Second Edition

Adding New Features to List and Combo Boxes

List and combo boxes offer various properties and methods that are accessible only through VBA code. The next two sections describe programming techniques that take advantage of additional list and combo box features.

Figure 29.11. The line items list box displaying rows from the Order Details table.

Iterating List Box Items and Selecting an Item

Access list boxes share many common properties with the native ListBox control of Visual Basic 5.0 and earlier. The ListCount property returns the number of items in the list, the ItemData or Column property returns a value from the list, and the Selected ...