I use the prefix pic, as in "pick from a list" for this.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
"Brian Kastel"
wrote in message ...
Set the RowSource property of the lookup to a query. You can sort your
query according to your heart's desires.

I've made a practice of never binding combo boxes to lookup tables
directly.
I create small queries containing the two or three fields in my lookup
table, and sort by the information field rather than the autonumber key
field. I save these queries with a "sql" prefix rather than "qry" prefix
to
differentiate them.


"Keith Davis" wrote in message
...
Is it possible to sort a table used in a lookup combo box
by a field other than the Bound Column? I am looking up
IDNO and would like to sort the IDNOs by the second
column NAME.

Thanks in advance!

Keith