>>>I have a report that is based on a view that uses variables that are selected from a form. How do I return a message if the resultant view doesn't match the selection data that was entered in the form. In the old days, I could use:
>>>
>>>if _tally = 0
>>>
>>>after my select statement. But now I don't seem to have that kind of control.
>>>
>>>Thank you.
>>
>>How about RECCOUNT()
>>
>>Craig
>
>Perhaps I didn't make myself clear. Sorry. Yes, Reccount() would have worked in the 2.6 days after running a SELECT statement. However, this report uses a view in the data enviornment, so I (seemingly) have no control of the SQL, or cannot test the RECCOUNT() or _TALLY like I used to do. Therefore, is there anyway to send a message to a user telling them their selection criteria returned no records?

RECCOUNT() works fine on a view. I use it all the time. My standard data entry form uses RECCOUNT() to determine whether or not the VCR buttons should be enabled or disabled.