Good Day Richard.  As per your suggestion to students back in Access Beginner, 1. watch the lesson all the way through first. 2. Then go back to perform the tasks in the lesson.

Because of that, I was able to sidestep the "Layout mode" issues you ran into between 11:25 and 21:38 of the lesson. So I skipped the code manipulations  you did to correct that problem.

Here is my question: Does the work you did to correct the Layout mode problem (11:25 to 19:25) affect setting the listbox labels to sort by their various columns?  

I ask because I created the sort buttons for First, Last & email fields before the Layout mode issues at 11:25.

Then I copied the same 2 lines of code as used for "First","Last" & "email" buttons, when creating the "Time" button sort(at 21:38). I changed the code to read:

    OrderBy = "LastAccessed DESC"
    ReloadCustomerSearchList
  
When I saved, closed, and reopened the QuickSearchF I got a Parameter Query window asking for input for "LastAccessed". I assume that means Access does not recognize "LastAccessed DESC". Also I get the Debug Window  and yellow hi-lite at the line:

OrderBy = "LastAccessed DESC"

It is a simple line of code, so I am confused.

I have done this lesson from start to this point (21:45) twice, with the same code error message/hi-lites coming at the same place in the process.

Prior to the sort button code at 21:38, things were going quite smoothly with the work we are performing on QuickSearchF.

Hopefully the above makes sense. Any comments are welcome.

Regards,
Bob

---

Reply from Alex Hedley:

Does the Field LastAccessed exist in the RecordSource of the Form?