Originally posted by rlculver
Hi There,

I have a number of questions within an Access Database which get read onto a VB front End (I am developing a Quiz). I would like the questions to be provided in a different order each time the program is run - Is this possble???

Thanks
I am assuming that you have a next button, or something to go to the next Question, or something similar. You can have a unique key, and load all the keys into a collection

Dim Col as Collection
Dim X as Long

set Col = new Collection

if not rs.bof or rs.eof
rs.movefirst
do until rs.eof
col.add(rs.keyfield)
loop
end if

do until X >= 1 and X<= Col.Count
x = rnd * Col.Count
loop

RS.MoveFirst
RS.Find "KeyField = " & Col(X)

display question