Sorting entries in a browse form

[miss_sunshine]

I have a form to browse through entries of a table. I have a field called "status", which is either "past" or "current". When browsing through the entries via the form I would like all "current" entries to appear first, and the past ones at the end. Is there a way to automatically sort entries this way, and to update every time "status" for an entry is changed?

 

[Ian Mac]

I have a form to browse through entries of a table. I have a field called "status", which is either "past" or "current". When browsing through the entries via the form I would like all "current" entries to appear first, and the past ones at the end. Is there a way to automatically sort entries this way, and to update every time "status" for an entry is changed?

You can base your Form on a Query rather than the actual table and set the 'Status' field to Ascending,
using a query rather than a table will also help you buffer the data.

 

[miss_sunshine]

I can't believe I didn't think of that!

Thanks a lot I will try it now