如何在未绑定表单上创建多值组合框 [英] How can I create a Multiple Value Combo box on an Unbound Form

问题描述

我需要您在MS Access 2007上的帮助.

I need your help on MS Access 2007.

我的MS Access未绑定表格存在很大问题. 如何创建不想绑定到表的组合框，显示多值列表?

I have a big problem with my MS Access Unbound Form. How can I create a combo box i do not want bound to a table, show a multiple value List?

该组合名为Sector，希望从下拉列表":肥料，种子，农药，兽医产品，动物饲料，常规下拉列表中以9的倍数选择这些值(在Access 2007中应该可以使用).

The Combo is named Sector and want these values to be selected in Multiples 9Which should be possible in Access 2007) from the Drop Down List: Fertilizer, Seeds, Pesticides, Veterinary products, Animal Feed, General.

我可以使用哪个选择语句或VBA代码.我需要一个解决方案来解决这个问题.

Which Select Statement or VBA code can I use. I need a solution to handle this please.

推荐答案

精确地说，ListBox控件将为您提供帮助.由于您在MS Access中使用它-使用向导可以轻松地进行操作，您可以在其中键入项目列表.或者，如果要使用VBA，则可以在Form_Load事件中使用ListBox控件的AddItem属性加载列表.

Precisely a ListBox control will help you. Since you are using it in MS Access - it makes it much easier with the wizard where you can type the items list. Or if you want to use VBA, then you can load the list using AddItem property of ListBox control in the Form_Load event.

这篇关于如何在未绑定表单上创建多值组合框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！