Random Order in Subform?

[Necro]

Hey there,

I have a form und I want the belonging subform to be arranged randomly on every access.

So: Group A,B,C (form) with each 10 different members(subform). You can change the group and so subform will give you the fitting members. And I want the order of the members to be random. Is that possible?

Thanks in advance

 

[llkhoutx]

Create a random long integer column if the subform's record source table and have it be the 1st column.