[RESOLVED] Access Option Buttons and Counter Loop

[dataempress]

Hi,

I was working in Access 2007, but was recently upgraded to 2010. I'm sure any advice given would be okay for either version.

I was asked to make a scheduling database for a conference. There are 7 workshops in my database, and participants are supposed to pick in order of preference ie Choice 1, Choice 2, Choice 3, etc. in case their first choices are full. I have option groups representing the choices. There are 49 option buttons in total, 7 representing the workshops and 7 representing each choice. I put validation code in my submit button to make sure the user doesn't try to select two of the same choice.

I'm having trouble with one thing, and this has stumped me for the three years I've been doing it. I try to improve the logic each year but I can never get past this hurdle. If Choice 1 is full, I want to automate the program to pick Choice 2, and all the way down the line. Right now, we're doing it manually. If Choice 1 is full, the user has to manually go in and change their choice 1. I'd like the database to automatically select choice 2 in that case, but I'm unsure how to do it.

I've tried including a counter and for/next loop in my submit button. Am I on the right track? Can I handle this all in one sub or do you think I need to be creating seperate tables for each workshop. I'd appreciate any advice you can give me. Thank you!