user variable for sorting records on a form

[krowe]

Hi All

I'm not sure if this should go in forms, querys or vba...

I have a subform that has a list of transactions for each customer. This is based on a query so that i could get it to sort by date.

some users prefer newest transactions at the top, some prefer oldest.

It is a split database and each user has his/her own copy of the FE.

I want to create a table called tblCustomise (stored in the FE only, not linked to the back end) with the field TransSort, which will be populated by a form called frmCustomise. There will be 2 options ASCE and DESC.

I then want the query to be able to pick up if the user wants to see the records in ASCE or DESC order and sort accordingly.

Is this possible?

If so I will use the table to customise many aspects of the database, think it will add loads of functionality.

Thanks in advance

Kev

 

[jdraw]

Try this site for some ideas to do what you want.

This will show a few forms and user selectable options, that will sort etc the way the user wants/prefers.
http://www.fontstuff.com/access/acctut19.htm