Quiz database, multiple random topics

[Robert Saye]

Hi all,

I finally figured out how to write a module to get the data I need. Now I am clueless on how to get it into a form. I am attaching my database if someone could take a look at it. What I am trying to do is use the testing() method which returns 5 random questions from 3 different catergories. I can get them to print out in the immediate window, but am lost on how to get them to a report.

Thanks in advance,
Robert

 

[Mile-O]

Have look at the example I posted on this thread.

 

[Robert Saye]

Mile-O-Phile is a freaking genius

Well, that was almost a perfect example of what I wanted. My only problem now is should I break up my database so it will fit your form? I have it in two seperate tables:

tblQuestions tblAnswers
QuestionID pk AnswerID pk
Question QuestionID fk
CatergoryID fk Answer
SourceID fk Correct

The problem is getting the answers into a subform? So I think I need help figuring out how to tell my subform to take all five answers whick all have the same QuestionID, and place them in individual textboxes.

Any Ideas?

Thank You,
Robert

 

[Mile-O]

Can anyone post a copy of the above attachment in '97, please?

 

[Autoeng]

Here ya go.

Autoeng

 

[Mile-O]

Thanks