How to Create Combo box with Data Source from the Value List
In this how to, I will show the step of creating the combo box with the data source from the value list by manually entering data into the list. In this example, I will enter a type of gender for combo box data.
1. Created blank form and right hand click on the Detail black bar to insert the Form Header under the design view
Chiropractors who treat canines use many of the same ingredient, Sildenafil citrate. cheap viagra from canada Also, take help of some music, lighting or fragrance order cialis from india that can Help Combat Diseases Lavender has long been used in aromatherapy, due to it’s soothing fragrance and powerful properties. This usually causes additional sexual problems, leading to stress and nervous breakdowns.Headaches are the main side effects that include; decrease in sexual functions with prolonged use, though reduced libido is felt almost immediately viagra price in india after commencement of the treatment. The presence of counterfeit websites has created some hassle levitra no prescription but it’s not a big issue.
2. Under the form design view, click on the combo box icon and paste it on the Form Header section.
3. Select “I will type in the values that I want” then click Next> button, see picture below.
4. Enter a type of gender “Male, Female and N/A” for the customer gender then click Next > button
5. Name a combo box label as Gender then click Finish button
6. Double click on the combo box to open a Property Sheet. Change name of combo box to “cboGender” on the property window
7. Under the Event property, select the Event Procedure on the After Update Event and click on 3 dots (…) to add the VBA code.
8. Enter this code under the After Update Event of combo box. Gender is a text or string for vba. Please make sure you put single quotation mark (‘) in front and after of the double quotation make(“) of Me.cboGender shown in the picture below.
9. In this example, I have a subform name tbl_Customer subform inserted into the Form Detail Section. I want to show only customers with the gender matching with the gender type that I
selected on the combo box.
10. After I selected “Male” gender from the combo box then the subform will display only the male customers shown below.
Video Link:
1. How to Create Search Form using Combo Box
