Hi Alex,
I have the search seminars, in particular which lesson??
Also in the SQL which lessons?
Are you able to give an example.

Regards
Stephen

---

Reply from Alex Hedley:

Search Seminar-
From the Outline
"Then we'll build something similar to the previous example, but instead of using filters will use SQL record source changes. Once again we'll see how to deal with blank values or NULL values in our search results."

Lesson 14: Modify the record source of the form using an SQL statement.

Can't remember which lesson in the SQL Seminar but as a whole it teaches you how to build SQL statements which you could use.

Via VBA you just need to build the string.
Then set the .RecordSource of the Form to that SQL.