MS-Access random record

[Morfeas2]

Hi,

 

I have created a database using MS-Access 97 and a form for displaying a specific table's fields. In the form I have a button. What I want is to make my form display a specific records' fields (selected randomly from my table) any time I click on the button. Does anyone have an idea as I have spent several hours on this?

[UserX]

mou fenetai oti i SQL pou prepei na baleis na trehei kathe fora pou tha kaneis klik sto koumpi einai i:

 

SELECT Top 1 MemberName FROM Members ORDER BY RND(MemberID);

 

me to "Top 1" pernei 1 timi. An baleis p.x. Top 2 tha pernei 2 tyxaies times apo to MemberID

[Morfeas2]

Οκ ευχαριστώ. Το δοκίμασα και δούλεψε.