Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to use "OrderBy" or "OrderByOn"
0 views
Skip to first unread message
Scott Hansen
Mar 31, 2001, 9:56:15 AM3/31/01
to
I am unable to get a combo box dropdown list to sort in Microsoft Access 97.
The data comes from acustomer table and the desired sorted field is
"Customer Last Name". The table has a primary key field of "Customer ID"
which is autonumbered. The dropdown
list of customer names always sorts using the primary key field even though
it is not shown. I think I need to use an "OrderBy" or "OrderByOn" property,
but I haven't been successful yet since I don't understand Visual Basic. I
cannot figure out the syntax since Access 97 provides no example. What
statement can I use to do this? Where exactly can I insert this statement?
Thanks for your help in advance!
Scott
Frustrated Neophyte
The data comes from acustomer table and the desired sorted field is
"Customer Last Name". The table has a primary key field of "Customer ID"
which is autonumbered. The dropdown
list of customer names always sorts using the primary key field even though
it is not shown. I think I need to use an "OrderBy" or "OrderByOn" property,
but I haven't been successful yet since I don't understand Visual Basic. I
cannot figure out the syntax since Access 97 provides no example. What
statement can I use to do this? Where exactly can I insert this statement?
Thanks for your help in advance!
Scott
Frustrated Neophyte
Patrick Goupell
Mar 31, 2001, 10:13:41 AM3/31/01
to
Set the 'orderby' property to customer last name. Set the orderbyon to
true. you can do this in the properties or in code.
true. you can do this in the properties or in code.
--
Patrick Goupell
0 new messages