put random row of data (from query) to form

[rwahdan1978]

Hi,

I have a query that will choose a random record (1 record) and now I want to put that record into a form controls, how to do that?

[June7]

Did you try binding form to query?

[rwahdan1978]

Did you try binding form to query?

Yes but I am always getting the same order say records (42, 10,11,etc...) no matter how many I re-run the app? It should be different everytime?

[Welshgasman]

If the query is choosing one record, how are you getting multiple records in the form?

[CJ_London]

Better show your query that generates the random record - sounds to me you are not seeding it

have you seen this link as to how to use the rnd function (I assume that is what you are using)

https://learn.microsoft.com/en-us/of...p/rnd-function

[señor_sriracha]

Here's a query that returns a single random row using a unique numeric field (preferably an auto-numbered ID if you have one).

SELECT TOP 1 * FROM table ORDER BY RND(table.id)