updating rcord numbers

[Guest]

I have a form , each record has an autonumber but also a number I gave it '
SID '
The form runs of a query which sorts by SID field
eg

Auto No SID xxxxx xxxxx
1 4
2 5
3 7
4 8
etc

1st problem - how do I constrain the user to type in 6 instead 0f 7 above ie
there should only be allowed a step change of 1 from the last record to get :
Auto No SID xxxxx xxxxx
1 4
2 5
3 6
4 7



2nd problem - once I have acheived the above I may wish to insert a record
between 5 and 6 (Field SID) - I dont want 5.5 etc
This would need to be called 6 and the next records should automatically
pick this up and scroll down 1 number - Note I would have to scrioll down the
numbers first as it will not let me label a record 6 where one has been
already labeled 6?

3rd problem - Bit like the above but may have to delete a record, how do I
select it and delete and then the other records would move up one to where it
was originally positioned

 

[Rick B]

One post per question please.

http://www.mvps.org/access/netiquette.htm

 

[Guest]

Its all part of the same issue isnt it in this case?

 

[Rick B]

You have posted the same thread in tow different newsgroups. You posted a
second time in one newsgroup.

You are correct - your post is fine. There is no problem including the
details in your post, but you should not post it in two different
newsgroups.

If you need to post a question to two different newsgroups (which you should
rarely need to do), then you can post one message, and have it go to
multiple newsgroups. This places a COPY in the various newsgroups. When an
answer is posted, it will appear in all the groups. This will let folks
know that the issue has already been resolved, regardless of where they view
your message.

To do this, when you post a message, just add the other newsgroups to the
"Newsgroups:" field in your message.

Hope that helps.