Dear Dawn,
Thanks Dawn. But I could not succeed. I am a beginner in
Access and hence request the exact syntex. Where should I use the
Switch funtion- in the query or in the combobox row source property?.
The Row source property for the unbound combobox is shown in my
earlier mail. If you can modify the row source property in your
reply, it would be very nice.
Thanks in advance.
Kumar Iyer
--- In [email protected], "Crosier, Dawn" <[EMAIL PROTECTED]>
wrote:
>
> 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/
