Combo Box Problem ...

[Russell Potter]

I have a Combo Box, named "cbo", on a "Form" variable named "f",
and, on "cbo", "Bound Column" is set to "1", "Column Count" to
"1", "Row Source Type" to "Value list" and, "Row Source" to "a;b;c",
so, if the following code works as expected, "x" should be set to "a",
"b" then "c" on each iteration of the loop:

Dim x, i as Integer
....
For i = 1 To f!cbo.ListCount
f!cbo = i
x = f!cbo.column(0)
Next i

However, on actually runnung the code, I find that "x" remains as the null
string
(""), so something's going wrong, but what is it?

Russell

[Allen Browne]

The combo can have the values a, b, or c.
Your code attempts to give it the values 1, 2, and 3.

Try setting it to ItemData(i).
From memory it's zero-baesd, so start the loop at zero.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Russell Potter" <rpotter AT iinet DOTnet DOT au> wrote in message
news:3f******** **************@ freenews.iinet. net.au...

I have a Combo Box, named "cbo", on a "Form" variable named "f",
and, on "cbo", "Bound Column" is set to "1", "Column Count" to
"1", "Row Source Type" to "Value list" and, "Row Source" to "a;b;c",
so, if the following code works as expected, "x" should be set to "a",
"b" then "c" on each iteration of the loop:

Dim x, i as Integer
...
For i = 1 To f!cbo.ListCount
f!cbo = i
x = f!cbo.column(0)
Next i

However, on actually runnung the code, I find that "x" remains as the null
string
(""), so something's going wrong, but what is it?

Russell

[Russell Potter]

Allen,

Thanks _very_ much for that info; I modified the code accordingly and it
works fine now ...

The reason I had set the combo box to 1, 2 and 3 is that I'd had it in my
head from somewhere that setting the combo box itself (rather than one of
it's properties) to a number would set the row of the combo box, but I was
obviously mistaken on that count, and "ItemData" must be the way to do it
instead

Sorry for wasting everyone's time ... :-)

Russell

The combo can have the values a, b, or c.
Your code attempts to give it the values 1, 2, and 3.

Try setting it to ItemData(i).
From memory it's zero-baesd, so start the loop at zero.

[Allen Browne]

Russell, no apology is needed, friend.

Your question was clear and concise, and you are very welcome.
Glad to know it's working for you now.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Russell Potter" <rpotter AT iinet DOTnet DOT au> wrote in message
news:3f******** **************@ freenews.iinet. net.au...

Allen,

Thanks _very_ much for that info; I modified the code accordingly and it
works fine now ...

The reason I had set the combo box to 1, 2 and 3 is that I'd had it in my
head from somewhere that setting the combo box itself (rather than one of
it's properties) to a number would set the row of the combo box, but I was
obviously mistaken on that count, and "ItemData" must be the way to do it
instead

Sorry for wasting everyone's time ... :-)

Russell

The combo can have the values a, b, or c.
Your code attempts to give it the values 1, 2, and 3.

Try setting it to ItemData(i).
From memory it's zero-baesd, so start the loop at zero.