Sorting Lookup tables

  • Thread starter Thread starter Keith Davis
  • Start date Start date
K

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
 
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.
 
I use the prefix pic, as in "pick from a list" for this.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
 
Back
Top