I would do a select first, I think you will find that it is easier to work with cursor to hold the report data than with individual tables.
SELECT [FieldList] FROM [Table] WHERE First_Name = "PEter Monica" INTO CURSOR C_DATA
IF RECCOUNT('C_DATA') = 0
ELSE
REPORT FORM REPORT 1 PREVIEW NOCONSOLE
ENDIF
>report form report1 for ((app.First_name="PEter Monica")) NOCONSOLE PREVIEW))
>
>but is there a way i can do an error message or a message box in the event PEter Monica doesnt exist? like...an else? i kno the logic but im not to sure how to implement that with a report. Unless if i do a query and select every one i(in a table /cursor) want to and just do a normal report?
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges