Randomize in Forms starts from same seed when opening form

[xxdocxx]

Hello Folks, I am very new to access and I have to fix a random test generator that an ex-employee created. The test generator will create test with randomly picked questions and answers. Unfortunately, when you close and reopen the generator it starts off with the same questions. I have tried using Randomize as a event procedure on load, but this is not working. Any help would be greatly appreciated.




Doc

[orange]

This link may be helpful.

[aytee111]

I've never used this before - thanks for the link, Orange.

What if you put a counter on the table where the questions are stored and every time you use a question add one to the counter, then each time you start the test start with the question with the lowest number?

[orange]

The secret is the use of RANDOMIZE.

Here is an example

'---------------------------------------------------------------------------------------
' Procedure : randomNumber
' Author    : Jack
' Created   : 11/18/2010
' Purpose   : To Generate Random numbers between and including a range of numbers.
'Lo and Hi are the lowest and highest random numbers you wish to generate.
'
'The Randomize keyword is critical to getting different results for each Access session.
'=======================================================================================
'---------------------------------------------------------------------------------------
' Last Modified:
'
' Inputs: N/A
' Dependency: N/A
'------------------------------------------------------------------------------
'
Function randomNumber(Lo As Long, Hi As Long) As Long
10       On Error GoTo randomNumber_Error

30    Randomize
40    randomNumber = Int((Hi - Lo + 1) * Rnd + Lo)

50       On Error GoTo 0
60       Exit Function

randomNumber_Error:

70        MsgBox "Error " & err.number & " in line " & Erl & " (" & err.Description & ") in procedure randomNumber of Module AccessM"

End Function

[aytee111]

This is great! Thanks

[xxdocxx]

Thank you, but this did not help. Still starting all tests with same questions on load.

[orange]

You should show us some code then.

If you randomize the record to start with (select a random question from your questions) then it should not be repeating. More info please.