Share this Page URL

Chapter 8. Adding Features and Function ... > Using a Control's Value in Query and... - Pg. 289

Adding Features and Function to Forms 289 3. 4. 5. 6. 7. In the first screen, keep the option to have the list box look up values in a table or query, and then click Next. Select Table:CampaignExpenseTypes as the table to provide the values for the list box, and then click Next. Move ExpenseTypeID and ExpenseType to the Selected Fields list, and then click Next again. Click Next in the screen in which you assign a sorting order (we don't need to set a sort order), and then click Next in the screen that shows the values in the list. (You can adjust the size of a column in this screen if you need to.) Enter Expense Categories as the list box's label, and then click Finish. Increase the size of the form if the controls make the form look too crowded. Also, move the label for the list box so that it's above the list box control. The form should look something like this at this point: