- if combo1 = blue then
-
combo2.text=small",
-
combo2.text="medium",
-
combo2.text= "large"
-
else
-
combo2.text=""
-
combo2.text=""
-
combo2.text= ""
-
end if
There is no way this code could ever work as written.
if combo1 = blue then
blue is text and would have to be enclosed in quotation marks
combo2.text=small",
combo2.text="medium",
Aside from the fact that
small only has quotes on one end, the
commas between the assignment statements have no place in Access syntax
Also, you can only use the
.Text property if the control in question has focus. Otherwise you have to use the
.Value ; Since .Value is the Default Property for a textbox/combobox, you can omit it, i.e.
combo2.Value = "small"
can be simply written
combo2 = "small"
And lastly, if you correct all of the above problems, since you're assigning three values to the combobox value property, only the last value ("large") will be present!
Linq
;0)>