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
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