fill form textboxes from users table

[rwahdan1978]

I have a query:

SELECT Users.UserName, Users.Score
FROM Users
ORDER BY Users.Score DESC;

the table:



The image:
The textboxes (top for usernames and bottom for scores) how to get the values from the query? I want to put all usernames from the query into the textboxes and I want to get all the scores from the query to the textboxes as well but all in one go. How to do that?

[Welshgasman]

Use a query.
Name the texboxes as txtWhateverEvernn where nn is a number, then allocate the query values and names to the respective textboxes.

[rwahdan1978]

Use a query.
Name the texboxes as txtWhateverEvernn where nn is a number, then allocate the query values and names to the respective textboxes.

I am really new to this, could you give an example or guide me with link tutorial to do that?

[Welshgasman]

No, sorry. I just am just mentioning the method I would use.

[rwahdan1978]

No, sorry. I just am just mentioning the method I would use.

I made this query that will sort them from largest to smallest. How to use the query to fill the textboxes?

SELECT Users.UserName, Users.Score
FROM Users
ORDER BY Users.Score DESC;

[Welshgasman]

Use that query as your recordset, read that and set the various controls/labels keeping count of the record number.
That is why I said the controls have to have a numeric portion, so you can tie each to their respective control.