Hello,

I would like to know how a user can go to a layout and not see the previous entry into that layout. When a user enters the layout they see the previous entry which they can edit. Only when new record is selected will all of the fields clear and then a new record can be added. I would like it to be clear upon entry to the layout.

Your help is appreciated

You haven't explained enough of your process to give me a good picture but try this:

Allow User Abort [ Off ] ... leave it ON until you are sure the script is perfect.

Go To Layout [ new record layout ]

Loop

Show All Records

Show Omitted Only

Exit Loop If [ not Get ( FoundCount ) ]

End Loop

New Record/Request

This leaves the User with only their new record in the found set. Why the loop? Because if this is muti-user and, between your Show All Records and the Show Omitted, someone else creates a new record, it will ALSO appear when you then Show Omitted. To end up with ONLY ONE record (the new record) this appears to be the safest approach.

However ... if they have access to the menu or status area then they can show the records again anyway. But then they could CTRL-N to create a new bogus record also; or perform another find. So these options should be removed. Sometimes using globals to create new records works the best. Again ... it would depend upon your solution.

LaRetta

Option 1:

If the layout is intended for new records only, script the access to this layout to include the new record step.

Option 2:

Two layouts.

X-1 will be the initial (view only) layout.

X-2 will be a (edit/new) copy of X-1.

Format all fields in layout X-1 to not accept input. Place two buttons on the page. Edit Current Record and Create New Record

Edit Current Record button runs a script to find of the current record then accesses the X-2 layout (which is unlocked) allowing editing.

Create New Record scripts a new record then accesses X-2 layout.

Return buttons/scripts can route you back to the X-1 (locked) layout.

Hello Laretta I used your idea and left out new record request.

I put buttons on the new layout for new and find records.

The fields clear and now they have a fresh screen.

Thanks for the information.

Thanks for the reponse Gar. I am sure your post would have worked but it was a little over my head. Thanks for your response

Don