Dear Richard,

Once again you made me look a fool. While watching Video 10 time index 13.50, i couldn't believe my eyes. How i wish i had watched this single line of code 3 months ago? It looks so simple but never did it ever cross my brain that it is possible. Have you demonstrated using the RecordSource property like this before? If you ever did, then i missed that class.

Regards,

MICAH

---

Reply from Richard Rost:

I know I've showed you how to create a query and then use that same query to feed a form and a report, but I don't think I've ever showed you this exact technique before (pulling the RowSource property out of a listbox to use it as the RecordSource of a report). Pretty cool, eh? That's why you want to learn SQL... once you know it, you'll realize that it sits under almost EVERYTHING in your database.

What I really like is that it's SO much easier to quickly edit, append, or delete records once you know the SQL action queries. You can do with one line of code (DoCmd.RunSQL) the same thing that takes 10 to 15 lines of code to do with a recordset... and I love recordsets!