Right off the top of me pointy little head, and assuming we're not talking massive numbers of records:
If you are populating the grid from the original file with a filter, place the "before" value in a variable, compare the 'before' and the 'current' and if 'current'<'before' place in reporting file.
or,
do the update to the original file on exit of the screen and do the lesser than test there.
>I need to read specific records from an inventory file and prompt the user with a listing (grid most
>likely) of those records. The user will key in a starting and an ending quantity for each item prompted.
>Of all those items, only those that have a lower ending number need to create records into a seperate
>table for reporting purposes.
>
>Suggestions on the best way to handle this scenario?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place