Yes, in your query for your combo box, use the Switch function.
Field: Customsort:Switch([title]="Vice President,Sales","a", _
[title]="Sales Manager","b", _
[title]="Inside Sales Coordinator","c", _
[title]="Sales Representative","d")
If you find that way too cumbersome, then I would setup a separate table
with all your pipes and have a Sort field in the table. Then you can
base your combo box using the sort table.
Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
This message was posted to a newsgroup. Please post replies and
questions to the group so that others can learn as well.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of access_kri
Sent: Sunday, February 26, 2006 12:49 PM
To: [email protected]
Subject: [ms_access] Assending order of combo box list
Dear All,
I have designed a database for displaying values from standard
Engineering Table. The form has a cascading combobox which the users
have to select. The values of other fields are displayed based on
engineering tables.
The data in the unbound combobox0 & 2 comes from the following
Combo0 Row Source Property: SELECT DISTINCT [qryPipeDimension].[Size]
FROM qryPipeDimension; and
Combo2: SELECT DISTINCTROW [qryPipeDimension].[PipeSch] FROM
qryPipeDimension WHERE ([qryPipeDimension].[Size]=[Forms]!
[frmPipeDimension]![Combo0]) ORDER BY [PipeSch];
The values in Combo0 representing pipe size in inches is not
displayed in proper order. It is displayed as 1, 1/2, 10, 1-1/2, 1- 1/4,
12, 14, 16, 2, 20 and so on. I want the pipe sizes to be arranged in
increasing order such as 1/2, 1, 1-1/4, 1-1/2, 2, 10, 14,
16 and so on.
Similarly, the combo2 values are displayed as 10, 10s, 160, 40
and so on whereas it should be ordered 10, 10s, 40, 40s and so on.
I would appreciate if the group can help me to order the values
of combo boxes as required. Is custom ordering possible.
Thanks,
Kumar Iyer,
Qatar
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
