2:58 Lesson 22
When I go to open the payee list from the main menu and select National Fuel, I get a Run-Time error '2447':  This is an invalid use of the .(dot) or !operator or invalid parenthesis.


This is what comes up when I hit Debug:
BillList.RowSource = "SELECT BillID, DueDate, AmountDue, Balance " & _
        "FROM BillsWithPaymentsQ WHERE " & WhereStr & _
        " ORDER BY " & Forms!PayeeF!SortBy

---

Reply from Richard Rost:

I need to see your WhereStr and SortBy to tell you what's wrong. MsgBox the complete SELECT statement (set it to a variable first then MsgBox it) and that should show you where the problem is.