Is there anyway to bypass the "no records match this request" message? I have built scripts whose functions are to display a list of a sales reps' scheduled follow-up calls. I have 2 databases; "sales leads" and "comments". A script in Sales Leads calls an external script in Comments

Go to layout ["login"]

Enter Find Mode[]

Insert Current Date["Call back"]

They then see a screen with the fields "sales rep" (drop down menu) and "call back" and a button that calls the script

Perform Find []

If [status(CurrentFoundCount)<>0)

Go to Layout [CommentbyDate]

Else

Show message ["No reminders scheduled for today"]

Perform Script [sun-scripts, external:"SalesLeads.fp5"] *Refresh window[bring to front]

End If

The problem with this set-up is that if no records are found and the user hits "cancel" in the "no records match this request" message, the record in browse doesn't appear any different than it did in "find" and I am leaving the record vulnerable to be modified.

[ November 12, 2001: Message edited by: RC ]

Set Error Capture[On]

Perform Find []

Set Error Capture[Off]

Will eliminate the error messages.

Just be aware that once error messages are off, YOU the4 developer are responsible for error checking. If no records are found, how will that affect the remaining part of the script?

Actually, will the script end with no rercords found or all records found?

CaptKurt's suggestion was perfect for my dilemma. If no records are found, the user sees a customized message ("show message") and is bounced back to the other database, insuring that the records can not be modified. Thanks for your help!