RANGE in ROWSOURCE, POSSIBLE?

A

amsuria

hi guys,

I would like to list down the following values in my ROW SOURCE TYPE -
"Value List":

0 - 10,000
10,001 - 20,000
20,001 - 30,000
30,001 - so on..

My problem is, I cant use 'COMMA' in my entry...

What should i do and how to do it? If you can give me other options, then
better..

Thanks..

Amsuria
 
A

amsuria

yeah, thanks..

hehehe.. so simple and yet i havent think of it..

thank you so much... that was really great!

amsuria
 
A

amsuria

awww! i tried to include it in my EVENT PROCEDURE and still, i got syntax
error - "EXPECTED END OF STATEMENT" ...

my code:

ElseIf cmbSearchWhat.Value = "Cubic Meter" Then
cmbSearchField.SetFocus
cmbSearchField.RowSourceType = "Value List"
cmbSearchField.RowSource ="1-10,000";"10,001-20,000"

tnx

amsuria
 
M

Marshall Barton

In this context, you need to use a string that results in
what Al said. Your assignment statement needs to be:

cmbSearchField.RowSource =" ""1-10,000"";""10,001-20,000"" "
 
A

amsuria

yay! i got it!!!

THANKS AL and MARSHALL!....

amsuria


Marshall Barton said:
In this context, you need to use a string that results in
what Al said. Your assignment statement needs to be:

cmbSearchField.RowSource =" ""1-10,000"";""10,001-20,000"" "
--
Marsh
MVP [MS Access]

awww! i tried to include it in my EVENT PROCEDURE and still, i got syntax
error - "EXPECTED END OF STATEMENT" ...

my code:

ElseIf cmbSearchWhat.Value = "Cubic Meter" Then
cmbSearchField.SetFocus
cmbSearchField.RowSourceType = "Value List"
cmbSearchField.RowSource ="1-10,000";"10,001-20,000"
Click to expand...
Click to expand...
 
Top