Sort Continuous form based on condition

[Lisad]

I have a continuous form with a description field. I have set conditional formatting to turn the background of the description field Red if the Diary field = Date(). This works great. BUT.... Is there a way to then display the highlighted records at the top of the continuous form or to SetFocus on them? At the moment we have to scroll down to see if any are red and sometimes miss them if we forget to look.

 

[Moniker]

Instead of sorting, why not just write a quick query like this:

SELECT * FROM YourTableName WHERE DiaryField = Date();

That will only return the records that have today's date in the Diary Field. You could easily place a button on the form that would run this query and show the results.