依赖组合框帮助 [英] Dependant Combo Box HELP
问题描述
对谁可以帮助我，
我是一个非常缺乏经验的程序员，我正在尝试创建一个依赖于另一个组合框答案的组合框。
例如：
我有一个组合框（Study Abroad），一个Catvar，有三个选择是;否;未知。如果选择是，则可以使用以下组合框（海外学习计划）来选择。如果选择其他两个选择，则海外留学项目应该变为灰色。
目前，我将进入AfterUpdate并构建包含此代码的事件过程：
Private Sub Combo39_AfterUpdate（）
Me！[留学海外课程] .Enabled = Me！[留学] ="是
End Sub
Private Sub Combo39_Current（）
Me！[海外学习课程] .Enabled =我！[留学] =是
End Sub
我一直收到运行时错误''438''对象不支持此属性或方法。
请有人，我不知道我做错了什么。任何帮助将不胜感激。
谢谢，
Stephen
To Whomever Can Help Me,
I am a very inexperienced programmer, and I am trying to create a combo box that is dependant on another combo boxes answer.
For example:
I have a combo box (Study Abroad), a Catvar, with three picks Yes;No;Unknown. If yes is selected then the following combo box (Study Abroad Programs) becomes availible to choose picks from. If other two picks are selected Study Abroad Programs should become greyed out.
Currently, I am going into AfterUpdate and building a event procedure containing this code:
Private Sub Combo39_AfterUpdate()
Me![Study Abroad Programs].Enabled = Me![Study Abroad] = "Yes"
End Sub
Private Sub Combo39_Current()
Me![Study Abroad Programs].Enabled = Me![Study Abroad] = "Yes"
End Sub
I keep getting a Run-Time error ''438'' object does not support this property or method.
Please someone, I don''t know what I a doing wrong. Any help would be greatly appreciated.
Thanks,
Stephen
推荐答案
在表单视图中加载表单之前，请转到[Study Abroad]的属性并选中Enabled to No
Private Sub Combo39_AfterUpdate（）
如果我！ [留学] =是然后
我！[海外留学项目] .Enabled = True
其他
我！[留学海外课程] .Enabled = False
结束如果
结束子
祝你好运！
Before loading your form in form view go to the properties to [Study Abroad] and check Enabled to No
Private Sub Combo39_AfterUpdate()
If Me![Study Abroad]="Yes" Then
Me![Study Abroad Programs].Enabled = True
else
Me![Study Abroad Programs].Enabled = False
end if
End Sub
Have a nice luck!
Peb说：
Peb said:
在表单视图中加载表单之前，请转到[Study Abroad]的属性并选中Enabled to No
Private Sub Combo39_AfterUpdate（）
如果我！[海外留学] ="是"然后
我！[海外留学项目] .Enabled = True
其他
我！[留学海外课程] .Enabled = False
结束如果
结束子
祝你好运！
Before loading your form in form view go to the properties to [Study Abroad] and check Enabled to No
Private Sub Combo39_AfterUpdate()
If Me![Study Abroad]="Yes" Then
Me![Study Abroad Programs].Enabled = True
else
Me![Study Abroad Programs].Enabled = False
end if
End Sub
Have a nice luck!
我仍然像以前一样得到运行时错误。另外，不应该将学习海外课程的组合框设置为否？否则我不能输入任何数据。非常感谢任何帮助。
-Stephen
I am still getting a run-time error as before. Also, shouldn''t combo box Study Abroad Programs be Enabled to No? Otherwise I can''t enter any data. Please any help would be greatly appreciated.
-Stephen
Whati是运行时错误，它出现在哪一行？
Whati is the run time error and on which line it appears?
这篇关于依赖组合框帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
