Recordsource problem

[BoardBabe]

Hello,

I have a form where I show a few records from my database based on a sql query in an overview :

SQL = "SELECT and so on"
Me.recordsource = SQL

This works fine. The user can also search in these records shown. The search works fine too. Now my problem : In the search criteria the user can also search for deleted records (so these records aren't shown in the overview). And because these records aren't shown in the overview, he won't search for them either, he just searches for the records in the recordsource (so the ones visible in the overview).

How can I solve this?

Thanks in advance!

[BoardBabe]

Problem solved