To do this, select “Name” in Control Source of Combo Box. If you bound the Combo Box to a field in Form Record Source, say a field called “Name”, the selected Combo Box value will save to that Record Source automatically. Since the display value of Combo Box come from Row Source, Control Source only serves the purpose of save value.įor example, the Row Source displays Employee Name (May, John, Peter), and there are three records in the Form Record Source.įor each Form Record, if you select the Employee Name in Combo Box, nothing will save. In other Controls, Control Source is how you want to Control (Text Box for example) to display value and save value. The Control Source of Combo Box and List Box is different from that in other Controls. Save Combo Box value – using Control Source Property Navigate to Form Properties > Data > Allow Edit, make sure the parameter is set to Yes By default, the value is set to Yes, you must set to Yes in order for Combo Box to work. Form Property – Allow EditĪllow Edit Property allows you edit data in Form. If you choose Field List in Row Source Type, and then select a Table name, you can choose the field name in Combo Box.Īt this point, the basic setup of Combo Box is complete. If you select Value List in Row Source Type, you will see a prompt in Row Source to define the list of Combo Box items, then it will convert this table to a string expression.įield List means the Field Name for the table or query. – If you want to sort Combox Data, use Query builder to sort or directly type SQL commandįor example, SELECT DISTINCT FROM SORT BY 2) Row Source Type = Value List If the list you select contains duplicate values, write a SQL statement with DISTINCT keyword to remove duplicates. Set Column Heads Property to Yes to display field headers (Combo Box Property > Format > Column Headers) The below example shows Column Width = 1 1 (or 1cm 1cm) To display more than one fields in Combo Box, navigate to the Combo Box Property > Format > Column Countīelow is an example of showing Column Count is set to 2įor multiple columns, you may also need to set the Column Width Property (Combo Box Property > Format > Column Width), your input should be separated by semi column for each column width. – If you directly select a Table name/Query Name that contains multiple fields as Row Source, only the first field is used in Combo Box list. The Table/Query can be different from the Control Source of the Form. You can select a Table Name, Query Name, or build a new Query in Query Builder by clicking on the … button on the right. Select one of the three Row Source Type depending on where your source come from. Navigate to Combo Box Properties > Data > Row Source, this is where you set the Combo Box values. To insert a Combo Box in a Form, navigate to Design tab and select Combo Box and drag down to the Form.Ĭombo Box Property – Row Source / Row Source Type If you try to open a Access Report based on search criteria, use Combo Box in Form and pass the Combo Box selection to Report Control Source, do not directly place a Combo Box in Report, because Report is used to display result. The advantage of Combo Box is that you can have control over what users will input, this will prevent unexpected input and typo.īecause Combo Box receives user input, Combo Box should be used in Access Form.
Ms word combo box how to#
This tutorial explains how to use Combo Box in Access Form and save selected value for use in another Form or Report.Īccess Combo Box value depends on another Combo Box Access Form Combo BoxĬombo Box is also known as Dropdown Box, which allows users to select data from a list by clicking on the down arrow button.
0 kommentar(er)
