Writing a select query in event and opening a recordset does not make the data available to report. But I guess this approach is abandoned and not important to flesh out your concept.