The combo box should be a useful way of setting the priority for each record - you can make the priority a numeric column, and hide the actual field while providing a text field that describes the priority associated with that number. One a record is marked complete, you can use the expression Me.Requery to display the remaining records.

I'm not sure I understand what you mean by "order number" - if you are talking about the sequence that records are entered, the way we do it is with and Identity property that is automatically incremented by SQL Server as new records are entered. There are other methods that involve finding the maximum value of a column and then incrementing it, but that become an issue with systems where there are a number of users entering new records. Hope this helps.