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/
