How to create combo box and list box controls in access form

When creating Access forms, combo box and list box controls are commonly used to help users enter and select data. PHP editor Apple will show you how to operate these controls, allowing you to easily create efficient forms. This article will detail the steps to create combo box and list box controls in Access forms to help you master this basic skill.

1. Open the database you want to operate, right-click the form where you want to add controls and select [Design View], or click the [Blank Form] button in the form group of the [Create] tab to create a new one Blank the form and enter its Design view.

2. Make sure the [Use Control Wizard] button is selected, then click the [Combo Box] button, and then click in the design view.

3. The system automatically pops up the combo box wizard, keep the system default settings, and click the [Next] button.

4. Select the source table to be used in the [Table or Query] list box in the opened interface, and click the [Next] button.

5. In the opened interface, all fields in the book classification table are listed. Here, select the [Category Number] item in the [Available Fields] list box, and click [Right] Click the [Angle Brackets] button to select the selected fields, and then click the [Next] button to continue.

6. Click the [Next] button three times in a row to open the combo box wizard completion interface. Keep the system default and click the [Finish] button to complete the combo box settings.

7. The design of the combo box is now completed. Click the View button in the [View] group of the [Home] tab, switch to the form view, and you can see the records in the bound fields. New records can also be entered.

The combo box control displays a column of data on the screen like a drop-down menu. Move the cursor to the desired option and click the mouse to complete the selection. List boxes are similar to combo boxes, but you can enter values ​​in combo boxes but not in list boxes.

The above is the detailed content of How to create combo box and list box controls in access form. For more information, please follow other related articles on the PHP Chinese website!