I made a form as per attached snapshot where the record can be arranged by pressing button up or down.
The arrangement of record is base on value in "sort" field which is automatically generated by VB and can be altered manually.
What I want to do next is to automatically change the value in "Sort" field when user delete some record. For example, there is already 30 records. User delete record number 15. Thus each record from 16 to 30 will become 15 to 29.
I'm stuck here.
Please give some ideas to accomplish this.
Thank you in advance.
The arrangement of record is base on value in "sort" field which is automatically generated by VB and can be altered manually.
What I want to do next is to automatically change the value in "Sort" field when user delete some record. For example, there is already 30 records. User delete record number 15. Thus each record from 16 to 30 will become 15 to 29.
I'm stuck here.
Please give some ideas to accomplish this.
Thank you in advance.
