Hi Again
Sorry, I need to do this problem using vba.
I have now made the tables tOption and tSelection. I also have a user table containing name and userID.
My Form has a UserID, first name and surname, option1, option2 and option3. The options are list boxes listing all the option...