Oracle Forms

Hello-

I am working on a form personalization to call up the Requisition Summary window from the Discrete Job window. I am using a global variable to pass the discrete job number to the requisition window. When the requisition summary window opens, its displays the requisition lines window. I then invoke query mode using ENTER_QUERY, pass the value of the job number and then EXECUTE_QUERY.

This customization is working fine when the discrete job has a requisition linked to it. When I have a job that is not linked to the requisition, I get stuck in a loop with an error that no records were found. Does anyone have a suggestion on how I can create a condition to cancel the query where there are no records found? I know that I can use COUNT_QUERY to display the number of records found, is there a way that I can get at that value?

Please advise.

Thanks,

Amy Bauman