ComboBox

[PeterM]

I have a combobox on a form. The source for the combobox is a value list
like: item 1;item 2; item 3 ... you get the idea.

I need those values in the drop down portion of the combobox AND I need to
run a query to pull distinct values from a table. I need this because my
users need a base core to be the defaults (item 1 - item 3) and to add any
new values previously entered. The combobox has limit to list is no.
Finally, they want the entire entry values to be sorted alphabetically. Is
there a way to do this?

defaults (in the value list)
item 1
item 2
item 3

values from a query
part 1
item 4

so the combined values for the dropdown portion of the combobox are:

item 1
item 2
item 3
item 4
part 1

Any help would be appreciated.

 

[alex]

I have a combobox on a form.  The source for the combobox is a value list
like: item 1;item 2; item 3   ... you get the idea.

I need those values in the drop down portion of the combobox AND I need to
run a query to pull distinct values from a table.  I need this because my
users need a base core to be the defaults (item 1 - item 3) and to add any
new values previously entered.  The combobox has limit to list is no.  
Finally, they want the entire entry values to be sorted alphabetically.  Is
there a way to do this?

defaults (in the value list)
item 1
item 2
item 3

values from a query
part 1
item 4

so the combined values for the dropdown portion of the combobox are:

item 1
item 2
item 3
item 4
part 1

Any help would be appreciated.

Peter,
I'm not sure what you're using your combo box for...with that said,
how many items in your value list? You could put those values in a
table and union them to the values in the table that you're apparently
appending to. You could then base your combo box on that union and
sort accordingly.
alex