How to fill a combo box from a column having values seperated by comma 1

[kosala1981]

i want to fill a combo box in a form, from a table's column data where that column has few possible values seperated by commas.

i just used a bound combo box but it filled values seperated by commas. how to remove these commas and fill values one by one, downwords.

i think it needs some code to eliminate those commas.
can someone tell me the answer please..

 

[PHV]

You may consider the Split function to build the combo's value list.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kosala1981]

i didnt get that. what's a split function and can u explain it more please

 

[PHV]

what's a split function
When in the debug window (Ctrl+G) type split and then press the F1 key.

 

[kosala1981]

well im new to programming and ms access.

thank u for ur kind help.