Error if no matching Report

[vivasuzi]

I have a report that gets info from a query. When the person opens the report, a pop up asks the first name they are looking for. If the first name is in the db, the report comes up fine. If the first name doesn't exists, the report comes up with #error everywhere.

Is there an easy way to display something else like "No records for first name of -first name entered-" ?

I'd like to show a message instead of just #error, since some people won't know that it isn't an error with the report. Thanx for any help

*Suzanne*

http://www14.brinkster.com/vivasuzi

 

[usgupta]

Suzanne,

When the user clicks the report button,
1. Show an Input Box and ask for the name
2. Open a recordset and get the count for the entered name
3. If recordcount is > 0 then
'Open the report and show
Else
Msgbox "Invalid name"
'Do not open the report at all and exit
End

Hope this might help you.

 

[glalsop]

Hi Suzanne -

Have a look at faq703-1594. It details exactly what you are trying to do.

Good luck

-Gary