Good Day All 
Is it possible to add a custom sort order to access 2003 form?
Instead of the sort order being ascending or descending from a query?
My data in ascending order at the moment is as follows:
Advice Centre, Assurance Section, Collectorate, Customer Relations, Customs Assurance, Debt Management, FCU, I.T. Section, Investigation Section, Legal Library, Preventive Section, Quality & Development, Support Services
What I would like to do; is achieve the data on the form to be displayed in the following order: Advice Centre, Quality & Development, Assurance Section, Collectorate, Customer Relations, Customs Assurance, Support Services, Debt Management, I.T. Section, Legal Library, Investigation Section, Preventive Section, FCU.
I understand I can do this by adding a sort column to the data table and numbering my sections as I want, however in the database I am using; this is not an option as the tables are linked to other databases and I only need this custom sort order for one form and nothing else.
Any help would greatly be appreciated :banghead:
Regards
Tor Fey
Is it possible to add a custom sort order to access 2003 form?
Instead of the sort order being ascending or descending from a query?
My data in ascending order at the moment is as follows:
Advice Centre, Assurance Section, Collectorate, Customer Relations, Customs Assurance, Debt Management, FCU, I.T. Section, Investigation Section, Legal Library, Preventive Section, Quality & Development, Support Services
What I would like to do; is achieve the data on the form to be displayed in the following order: Advice Centre, Quality & Development, Assurance Section, Collectorate, Customer Relations, Customs Assurance, Support Services, Debt Management, I.T. Section, Legal Library, Investigation Section, Preventive Section, FCU.
I understand I can do this by adding a sort column to the data table and numbering my sections as I want, however in the database I am using; this is not an option as the tables are linked to other databases and I only need this custom sort order for one form and nothing else.
Any help would greatly be appreciated :banghead:
Regards
Tor Fey
