insert an item in between - List Box Move Item in Microsoft Access 3


	Back to List Box Move Item 3 Comments List

Upload Images @Reply Bookmark Link Email

insert an item in between

Ludwig Willems

18 months ago

Hi Richard
What if I want to insert an item in between in the list of the table, in other words, for example, I want an item between record 3 and 4. The new item then becomes 4 and the next items have to move the number up. Is this possible. The records that follow are all increased. This could happen with my database. They are groups of certain modules that must stay together.

	Sami Shamma @Reply 18 months ago
Are you talking about AutoNumbers? If so the answer is no. But that is not what AutoNumbers are for. Use your own sort field if you need to keep records together. Initial Sort Order

	Ludwig Willems OP @Reply 18 months ago
no, no AutoNumbers, but own numbers, but sometimes a record would have to be inserted and then the own numbering would have to be moved.

	Adam Schwanz @Reply 18 months ago
If you are assigning your own numbers, you would need to update all the records that are greater than that. You could use a recordset to do that. Just go through all the records and do rs!YourNumber = rs!YourNumber+1 for instance

	Sami Shamma @Reply 18 months ago
Ludwig Adam advice is excellent. Going forward you can do the following: 1) update all the numbers by multiplying them by 10 or 100 so 1,2,3,4 will become 10,20,30, 40 etc. 2) now you can easily insert numbers in between. So after 20 you can insert 22

This thread is now CLOSED. If you wish to comment, start a NEW discussion in List Box Move Item 3.