Value List. Row Source!

[cap.zadi]

Hi

Is it possible to populate next Row source of Value list while entering the data in form?
Or all values of Row Source should be populated in ascending order?

Row Source values example:



"ARS02";"ARS01";"ARS001";"ARS002";"ARS005"

Kindly advise

[isladogs]

Why not use a table to store these values instead so you can easily sort the values as you wish

[cap.zadi]

Hi

even we had table for these items but again have to select via combo box at a form to enter the data against each field.

so question is how to select all these items once at continuous form or display next by next at tab click.

[isladogs]

Yes but that's the whole point of a combo box - to select a record from a list
Using a table of values its easy to sort the records - using a value list its much harder

If you want to select all items, use a multiselect listbox instead
If you always want to select all items, then remove the combo/listbox and just load the entire dataset on the form, unfiltered

[cap.zadi]

Hi

Thanks for the valuable suggestion.