I am attempting to design a quiz program that will select one question at random from a database (MS Access) and display it along with its four possible answers in a form. The ‘Quiz’ table within the database contains 40 questions each with a unique number identifier (i.e QuizID field), four question fields (i.e Question1, Question2 etc) and a field containing the correct answer. The VBScript below connects the database to the form, however I do not know how to randomly generate a question and its choice of answers to the form??
Also, is it possible ensure that questions are not repeated with this code?
Any help, suggestions, pointers, or advice would be very welcome!!
Thanks for reading.
Dim accessDb, DSN1, dbConnection, dbQuery, recordSet