sorting combo boxs

[Onslaughtdave]

Hi,

Is there a way to sort the info automatically in a combo box. Yes i know i can sort the table/query that the combo boxes displays ... but what happens when enter a new record into that table, does it automatically re-sort itself or what?

thanks,

dave

 

[PHV]

Add an Order By clause in the SQL instruction of the RecordSource property of the combo.
The combo values will be sorted on each Requery.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Onslaughtdave]

Yep. thanks