Combo box dont let me select use the data I want

[Dive1]

Hello I want to use a combo box for his search field but when I select the data base I use for the combo box I cant select the the table with the value I want I have all the others but not the one I need, it's a integer table it's not accepted in combo box ? in my drop down it work fine but I really need a combo box any idea ?

[Drrickryp · Accepted solution]

@Dive1

Search only works on text fields. You can add a column of concatenated text to the integer and search on that. You would need to sort on the integer column. 

[Dive1]

oh okay thanks I'll try to change my table so and see if I can select it. 

[Drrickryp]

@Dive1

No need to change the underlying data. Use AddColumns() to reshape the table. 

AddColumns(YourDataSource, "IntText", Text(Int))