>>Hi Jim
>>My user want to be able to INSERT a record (using a GRID) right below the current record by clicking on a INSERT button. The table I am using only has 3 fields, NAME,DATE,SORTFLD. In most cases the dates will be the same value. I am having problems on how to approach this problem. I can use the SORTFLD (a float) to do my sorting. There will probably not be anymore than five records in the GRID. This is my problem. :)))))))
>
>Robert, when the suer clicks the button the recrod pointer in the recordsource for the grid is sitting on the record tehy were on. You can simply
>
>
>INSERT INTO GridSource (SortFld)
> VALUES (GridSource.SortFld + .001)
>
>Then refresh the grid.
---
Hi Jim
Your code does INSERT a record, but what if the user tries to
INSERT a record using the record they just inserted as the current record.
example…
SORTFLD = 2.000
They insert and the new record is SORTFLD= 2.001
The current record is SORTFLD= 2.001
They insert and the new record is SORTFLD= 2.002
The current record is SORTFLD= 2.001
If they insert here, the new record will be SORTFLD= 2.002 (again)
What do you think?