Hello:

I am trying to make a layout where the user can modify a record. I made it with an OK and a Cancel button. I have the OK button just take the user back to the main layout, so that works ok, but I have a few concerns.

First, when a person is modifying a record, I don't want them to be able to scroll to the next or previous record. I don't suppose there is a way to prevent the user from scrolling, is there?

Also, I was wondering if anyone has ever used a Cancel button before. When the user modifies the fields, I would like to have a Cancel button so they can revert back to the old field values when Cancel is clicked. Any pointers here would be great.

Thanks all!

Ken

The most common way to do this is to find the current record (Show All Records, Omit Record, Show Omitted). Set up the layout so the user is entering inot global fields, not the "real" fields. The OK button runs a script that puts the gloabl values into the corresponding real field. The Cancel button just goes back to the main menu (and clears the global fields if desired).

Wow. Thanks Vaughan. It's so clear now. Thanks for the input... that should work perfect.

Ken