so having a primary key wouldn't work
If you mean for re-ordering using the method I came up with, then I disagree completely.
placing the key information in one central place so there's no need to waste time searching for information.
Then this approach will only cause you grief or at least impose limitations on what you can do with it. Sorry but the comment makes no sense to me. A properly normalized structure doesn't make presentation of data more difficult. If anything, it makes it better. Seems to me that you should be updating existing tables based on ODBC data, not replacing everything each time you get the data. At least that has been my approach.
I suppose a number field that defaults to 0 would solve having non-prioritized events at the bottom of a list, but so would basing any form on a query instead of a table, which is my usual practice. You would find unaddressed items in a snap via query criteria.
I see that you have 'section manager' as priority value in your form in one record. Is that valid, or a mistake? The form priority field is free text, so I could just as easily typo HIHG as I could HIGH. You might find that you're overlooking records when such important data is free-form. A better approach might be a single form with datasheet. While combos provide a nice way of controlling such input, they are a bit problematic when used on continuous forms and if I recall, not functional in a datasheet at all.
EDIT:
I went ahead and tweaked the db that I posted earlier. Now it has the ability to move up one instead of just to the top. I think it's pointless to have the ability to move down as one would simply choose the one below and move it up. Also, there is a test to see if the listbox has header row or not and adjusts the list count accordingly rather than simply hard coding that in as I did in the prior version. I left the ID field visible as I find it easier to monitor the results against expectations, removed the module level variable and moved code off of the current event. That's about it, I guess.
EventSort.zip
Last edited by Micron; 10-25-2018 at 11:01 AM.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.