列表框并将选择设置为条件 [英] listboxes and setting selection as criteria
问题描述
有谁知道怎么做?
我想创建2个列表框。每个列表框必须包含已导入的表中的列。第一个列表框示例:
288394 CALVIN KLEIN ESCAPE(500mL)
239484 HUGO BOSS(650mL)
874257 JEANPAULG( 500mL)..依此类推
第二个列表框必须包含Cities。 (也取自excel制作的表格)
现在,我希望能够选择一个产品,选择一个特定的城市,然后按一个命令按钮,这样它就会指引我一个屏幕让我知道在该特定城市订购或销售了多少产品。
有什么建议吗?
< blockquote>首先使用列表框向导。它将指导您准确创建列表框所需的内容。
如果您打算将这些列表框用作选择查询的过滤器或条件(对于您的表单)那么你想确保你只允许一个选择,否则就会涉及编码。
如果你已经有了想要构建表单的查询,那么粘贴到这里,我们将帮助您设置它以使用新的列表框。
J
我该怎么做?
我的列表框已设置,但我不知道如何创建一个返回信息的按钮。例如,如果您在1个框中单击432489 calvin klein,然后在另一个框中单击calgary,则单击搜索..我希望搜索得出卡尔加里432489 calvin klein的所有订单的结果。
Does anyone know how to do this?
I want to create 2 listboxes. Each listbox must contain a column from a table that has been imported. Example for the 1st listbox:
288394 CALVIN KLEIN ESCAPE (500mL)
239484 HUGO BOSS (650mL)
874257 JEANPAULG (500mL) ..and so on
The second listbox must contain Cities. (also taken from a table made in excel)
Now, I want to be able to choose a product, choose a specific city, and press a command button so it will direct me to a screen that lets me know how much of that product was ordered or sold in that particular city.
any suggestions ?
Begin by using the listbox wizard. It will walk you through creating exactly what you want for your listboxes.
If you plan to use these listboxes as a kind of a filter or criteria for a select query (for your form) then you want to be sure that you only allow a single select, otherwise there''s coding involved.
If you already have a query that you want to build your form on, then paste that here and we''ll assist you in setting it up to use your new listboxes.
J
how do i do that?
my listboxes are set up, but i dont know how to create a button that returns information. example, if you clicked 432489 calvin klein in 1 box, and then calgary in another, then click search.. i want the search to come up with the results of all the orders of 432489 calvin klein in calgary.
这篇关于列表框并将选择设置为条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!