Disable Sort on a form

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hi Everyone,

Access 2000. I have a text box on a form. The form is linked to a query.
I have a concatenated field on my query which is Name: FirstName LastName.
In the query I have sorted by last name. The problem is that the users
sometimes need to use the a to z sort for other fields on this form and once
in a while someone does an a-z sort on the Name field. Since they don't
have access to the query, the only way to get the names back in proper order
is for me to go in and resort the query. Is there a way to lock in the sort
order in this field on the form?

Thanks,
Linda
 
Hello there,

First way
I would create a second query which shows the records sorted according to
another field, e.g. FirstName.
Then I would create a macro to ApplyFilter - my new query.
I would create a command button on the form in order to run that macro.

Second way
I might create a custom toolbar in order to be used for sorting.
Hope this will help you

Regards,

George

Ο χÏήστης "LMB" έγγÏαψε:
 
Don't use the a-z sort. Place the LastName in the first column of your query
and place Ascending in the Sort row. Every time the query is run it will
sort by Last Name.
 
Back
Top