Thank you for taking the time to respond. I believe that I already have what
you have outlined but I am not sure if I am implementing it correctly. Currently
the control source for the combobox on my Members form is a field in my
Members table, GradeAttempting. For the row source I am using the following
SELECT GradeTypes.*, GradeTypes.GradeTypeID, GradeTypes.GradeType FROM
GradeTypes ORDER BY GradeTypes.GradeTypeID, GradeTypes.GradeType DESC;
The table GradeTypes has a field, SortField, which is what you recommended.
As I noted, I am not sure if my implementation is correct. If not, what
changes would you recommend?
Additionally, would an update query be able to select the next GradeType? If