Multiple Recordsets Show If

Hi I have multiple recordsets and I need to be able to say "sorry no records
found"

I am sending over an id that looks through 3 tables and only want it to say
'sorry no records found' when they are all empty.

How can I do this?

Speegs

Can't you simple create a text that says "no records found" use the 'show if
recordset is empty' server behavior and then use your SQL statement to set
the actual conditions to search.

If you set the SQL correctly, if the recordset is empty, only the text will
show. I have done it a dozen times.