Hello,

I am a newbie and am having a bit of difficulty with a database issue. I created a database in Microsoft Access and it contains a list of Questions with multiple choice answers. I setup a database in Visual Basic with labels for the questions and answers.

My problem is how to randomly setup the correct answer so that - for example answer (a) will not always be the correct answer. In my database the correct answer is in a field titled answer. So I need the correct answer to be in a different place as the user goes to the next question.

I used data1 and labels. In the labels' datafield property I chose the appropriate datafield. Example - The question label's datafield is obviously "question" (from access). But the other four labels would all remain the same as I clicked through to the next recordset, ie. answer A would always be the correct answer. I could go into access and change the order of answers. But, later I would not be able to randomize the answers, so that the user wouldn't remember the order of questions.

Thank you for any help.