Sorting Lookup tables

[Keith Davis]

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

 

[Brian Kastel]

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.

 

[Adrian Jansen]

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

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control