Ask Your Question

Base's form mode doesn't save sort criteria

asked 2015-11-15 05:59:33 +0200

Jamesff gravatar image

Why does Base's form mode always reset a sorted list of entries to its original order instead of saving the new sort criteria I enter?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-11-15 16:29:34 +0200

updated 2015-11-15 19:18:58 +0200

Is your form built on a query that has a sort? In this case overrides the ordering of the query.

If my answer helped you, vote it with ✔ and with (here on the left)

edit flag offensive delete link more


No it isn't. It's drawn from a table that had no sort order at the time I made the form.

Jamesff gravatar imageJamesff ( 2015-11-15 23:21:13 +0200 )edit

answered 2015-11-16 00:11:48 +0200

peterwt gravatar image

updated 2015-11-16 15:50:35 +0200

I have found an odd way to do this.
Open the Form in edit mode. Click the icon to turn edit mode off and the Form will display the data. Set the sort requirements and the data will be sorted. When you close the Form you will be asked if you want to save it - yes. When you open the Form again the sort requirement will be set as you wanted. I can not find any way to set it directly in design mode.

EDITED 16/11

Found the answer.
Open Form in Edit mode. Click on any control to select it. Right click - select Form to bring up Form Properties. On the Data Tab there is Sort where you can select the Sort requirements by clicking on the 3 dot icon on the right.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-11-15 05:59:33 +0200

Seen: 245 times

Last updated: Nov 16 '15