I have a form that is used to view customer information. There is a sort function in the query that the form is build on that sorts by customer name.
When applying a filter sort, there is no problem. When the database is closed, the filter goes away.
However, if an A-Z sort is applied (e.g. to the address field), this sort remains after the program is closed and the sort in the query doesn’t work any more, although it still appears in the query itself. I can’t seem to find the A-Z sort anywhere.
In order to return the database to the original order, I have to perform an A-Z sort on the customer name.
Access XP Pro on Win XP Pro on a network.
When applying a filter sort, there is no problem. When the database is closed, the filter goes away.
However, if an A-Z sort is applied (e.g. to the address field), this sort remains after the program is closed and the sort in the query doesn’t work any more, although it still appears in the query itself. I can’t seem to find the A-Z sort anywhere.
In order to return the database to the original order, I have to perform an A-Z sort on the customer name.
Access XP Pro on Win XP Pro on a network.