Display random record with button

[shredsec]

My button runs a query that finds a random record from my table (the code is below). But when I press the button to run it, the query opens and doesn't display my data in the form.

SELECT TOP 1 [>75 employees].*
FROM [>75 employees]
ORDER BY Rnd([id]);

[ssanfu]

That is all of the code for the button??

[shredsec]

That is all of the code for the button??

The code runs the query and I've added a button that runs the code. It's obviously missing something because the result of pressing the button on the form is that a datasheet view of the random record is displayed.

[shredsec]

I found the answer elsewhere on the web...add this code into the button's click event and it displays a randomised record:

DoCmd.GoToRecord , , acGoTo, Int(Rnd() * Me.RecordsetClone.RecordCount) + 1