Random Opening Forms (1 Viewer)

[Brian900]

I will have 4 different forms based upon 4 different tables. What I would like to do is create an event or create an autoexec macro to randomly select one of the 4 forms to open (Form1, Form2, Form3 and Form4) each time the db is opened. Any thoughts on how to accomplish this?

 

[ghudson]

Why?

The Rnd function will create a random number. You will then need to assign a value to your forms and open the corresponding form.

HTH

 

[Brian900]

I have four different test for people to take because someone could just record the answers and give them to the next person. I would like to combat that by randomly opening a different test each time. Thanks.

 

[Rich]

I'd have thought that one table with questions would suffice, then just randomly select the questions

 

[Brian900]

That would work also. I just need to know how to use it. Thanks.

 

[Mile-O]

Mile-O-Philes's Random Test Generator

 

[Brian900]

Mile-O-Phile,

This is pretty cool! Do you mind if I use and modify the code to complete my project? I'll drop you a comment within.

Thanks, Brian.

 

[Mile-O]

No, probs - that's what it's there for.

 

[Brian900]

Thanks. I'll let you know how it turns out. Brian