我的两个动态组合框的问题 [英] my problem with two dynamic combobox
问题描述
您好。我正面临访问问题，导致我延迟一周提交我的库存数据库项目，我将其用于我们部门使用的计算机设备。
我制作组合框，名称它（电脑公司的品牌名称）。其他组合框，向您展示计算机的模型。我想当用户选择计算机公司的名称然后模型的下一个组合框仅显示该公司的模型。
问题是例如当我选择hp copmany并且我去下一个组合框将显示我的hp型号，但hp的型号为ex：
1- dv5
2-dv6
3-pavilion 3847
当我选择第二个或第三个模型然后只会选择第一个填充组合框因此我需要让组合框选择任何项目组合框。
我希望你理解我。
谢谢。
Hello. I am facing a problem in access that cost me delay one week to submit my project of inventory database that I make it for computer device that used in our department.
I make combobox, name it(brand name)of computer company. other combobox that show you the model of computer. I want when user select the name of computer company then the next combobox of model display only the model of that company.
The problem is for example when I select hp copmany and I go to next combobox that will show me onle the model of hp but the model of hp for ex is :
1- dv5
2-dv6
3-pavilion 3847
when I select the second or third model then will only select the first one to fill the combobox so I need way to make combobox select any item of combobox.
I hope you understand to me.
Thank you.
推荐答案
这需要VBA编码。
第二个组合框（Combo2）的记录源需要根据第一个组合框（Combo1）的值进行过滤。
您可以使用第一个组合框的更新后事件来相应地更改第二个组合框的记录源。
co de将是这样的：
This requires VBA coding.
The recordsource of the second combo box (Combo2) would need to filter depending on the value of the first combo box (Combo1).
You could use the after update event of the first combo box to change the recordsource of the second combo box accordingly.
The code would be something like this:
谢谢史蒂文帮助我
i需要特定的代码请
因为我没有清楚地听到变量清楚听到
i你不明白你想要的记录来源
你的意思是行源或控制源!!
行源是模型查询
控件来源是设备信息_模型
表格名称是GQ表格
第一个c ombobox名称是BC
secomd组合框名称是MC
谢谢...
thank you steven to help me
i need specific code please
becuase i don''t understrand the varible clearly hear
i don''t understand the recordsource you want
do you mean the row source or the control source!!
the row source is Model Query
the control Source is Device Information_model
name of form is GQ Form
the first combobox name is BC
the secomd combobox name is MC
thank you...
你为什么不玩表格上的示例过滤一段时间。它应该可以帮助您清楚地理解问题以解决这个问题。
PS。请不要通过即时消息请求帮助。这是违反网站规则的，不会被容忍，因为它与我们的专家无关。
Why don''t you play around with Example Filtering on a Form for a while. It should help you understand the issues clearly enough to handle this problem.
PS. Please do not request help via instant messaging. This is against site rules and will not be tolerated as it is inconsiderate of our experts.
这篇关于我的两个动态组合框的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
