Using DLookup to get calculated value from a query to a form field
I have a query that calculates a score and I want to show that value in a form textbox.
I used the Dlookup function on the control source of the textbox ------> =DLookUp("Score","qryScore")
My problem is that the textbox now shows only the first result of the query for all the records.
How can i fix that?
That's 500 easy points! :)
Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.