lookup lists alphabetized???

[hunterfan48]

hey, so I know I'm gonna be told that I shouldn't be using lookup fields but I am because it works really well for my card database so please jus bear wit me and help me out if you can.

I have a look up list of values I manually entered myself...I was wondering if there was a quick and easy way to alphabetize them??

thanks in advance,
brady

 

[gemma-the-husky]

use a query based on these values to drive any lookup tables

in the query, by the column you want to use (ie the name), change the blank for "sort" into "Ascending". Open the query directly, to see what it looks like. Make the first column of this query, the id number, and the second column, the description.

change the lookup row source in the combo box on the form, to use this query, rather than what is already there.

this is the same, probably, as adding ORDER BY etc, at the end of the text that you will see - but it will be clearer what is going on.

 

[Rabbie]

hey, so I know I'm gonna be told that I shouldn't be using lookup fields but I am because it works really well for my card database so please jus bear wit me and help me out if you can.

Nothing wrong wit using look-up fields on a form. Its only in a table they are a no-no

 

[hunterfan48]

use a query based on these values to drive any lookup tables

in the query, by the column you want to use (ie the name), change the blank for "sort" into "Ascending". Open the query directly, to see what it looks like. Make the first column of this query, the id number, and the second column, the description.

change the lookup row source in the combo box on the form, to use this query, rather than what is already there.

this is the same, probably, as adding ORDER BY etc, at the end of the text that you will see - but it will be clearer what is going on.

I didn't use a lookup table... I entered the values manually myself. Can I still alphabetize the list?

 

[DCrake]

If your lookup uses a value list instead of a table then I would have thought it would have been more prudent to alphabeticalise them prior to entering them. How many items do you have in the list? Is this list likely to change?

 

[hunterfan48]

1) I'm adding cards from different sets and there will always be new card products coming out so no there is no pre-determined way to put the lists in alphabetized

2) this list will be changing quite a bit...or jus adding items to the list...I have it on 'edit value' so i can add different sets to the list when I come across a new one...

 

[DCrake]

That being the case you definately need to create a table to hold the codes and descriptions that way you can manage the list as you require.