Prioritise and move values

[misslee1888]

I have a form which has a checkbox which allows a case to be marked for review. What I want is that if the case is marked for review, I want to be able to able to view these calls and change a priority and order of these cases. I will always have 10 priority spaces and I want to be able to move them up and down priority accordingly. I should be able to report on this.

Thanks

 

[MStCyr]

I believe that the sample I've posted in the SAmple Databases area might be of some help.

http://www.access-programmers.co.uk/forums/showthread.php?t=103456

 

[misslee1888]

Thanks I will have a look at this.
The problem that i have is that I only want to prioritise cases that have been ticked as important. So not all cases in my database will have an order number to prioritise by. They will only be given an order number to be prioritised when the check box has been ticked.