Sorting on a form

[Ayiramala]

Hi,
I have this form for data entry. I want to sort a field in a certain way which is neither ascending nor descending. The items in this field should be ordered as say, C, A, D, B. What I want is a custom order. How can we do it?


The field I am referring to is not on this form, but in the underlying table.
I am thinking of a VB code to achieve this purpose, where I can define the order. But not sure how to do it.
Any help is greatly appreciated.

[June7]

There is only ASCEN or DESC. Need a field in table or query that has value you can use to get the desired order. What are your rules for the order you want?

[Ayiramala]

The field I am referring to contains names of certain subjects. The order I want is: Computer Science, Biology, Political Science, Computer Application (in this order). I temporarily solved it by creating separate forms for each.
Any way to do it as one form, in the given order?

[orange]

Create a sort field in your record and value it such that it sorts in the order you want.

[June7]

If you have only the 4 items, an expression in query can calculate a field that can be used to sort by.

Switch([fieldname]="Computer Science",1, [fieldname]="Biology",2, [fieldname]="Political Science",3, [fieldname]="Computer Application",4)

Otherwise, build a table of these values and have a field for SortOrder value. Join this table to the data table in query.

[Ayiramala]

That was indeed great. I did as directed, and got it right. Thank you very much.