Re: FORMS 4.5

D.D. wrote in message <848ihk$gmo$2_at_bgtnsc01.worldnet.att.net>...
>I'm using Forms 4.5. I do not know how to write this code AND get it to
>work.
>I have two blocks, and when I execute a query it works. I currently have
the
>second block as a Detailed block. If I put in a Part Number, the rest of
>the record is found. But if there are no records that match the criteria
>(Part Number), I want to be able to create a new record and get the form to
>become blank. This sounds easy, but I can not get it to work. Can you
>help?
>
>Forever needing help!
>Jeannie
>

I use forms 5.0, but the following suggestions should work well.

If part number is not found, then go to the block where you want to create new record and issue
clear_block. Then issue create_record.

good luck Received on Wed Dec 29 1999 - 05:17:02 CET