Combo Box Order

[tMitch]

Hi -

I’m can’t seem to get the order of records in my combo box to work. The control source is PlantID from tblPlantCharacteristics. The rowsource is tblPlantList and the order is set to ascending by BotanicalName in the rowsource query.

The order is correct when I run the query and in the pull down list. However, I want the order of the records as I scroll through to also be alphabetical – instead they are in the tblPlantCharacteristics.PlantID order.

Should I have done this differently? Is there some way to get the order by BotanicalName when there is no botanical name in the tblPlantCharacteristics??

 

[Jack Cowley]

Hmmm, you say, "Is there some way to get the order by BotanicalName when there is no botanical name in the tblPlantCharacteristics?" If there is no field in your table called BotanicalName then how can you sort on something that does not exist? If your statement is in error then create a query based on your table with PlantID in the first column and BotanicalName in the second. Set the Sort field for Ascending in the BotanicalName column. Close and save the query. Set the combo boxes Row Source to this query and hide the PlantID column and show only the BotanicalName column.

hth,
Jack