If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting Lookup tables
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 |
#2
|
|||
|
|||
Sorting Lookup tables
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 |
#3
|
|||
|
|||
Sorting Lookup tables
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 |
Thread Tools | |
Display Modes | |
|
|