Calculated field using DLookup from query not updating

[Tiffer]

I have an unbound text box in a form where I need to look up a value from a query called qry_Fees to obtain the value in the field [SumOfFee] where the field [Picture Index] in the query is the same as the field [PictureIndex] in the form and am using the DLookUp formula below



DLookUp("[qry_Fees]![SumOfFee] ","qry_Fees"," [qry_Fees]![PictureIndex] = [PictureIndex]&quot

When the form is opened the value is correct for the first record, but when I scroll through the records it remains the same. I have read numerous threads and have not found a solution. I have tried putting code to both refresh the query (which I don't be lieve is necessary) and recalculate the form, but may not have put them in the right place.
My questions are:
1. Is there a problem with my syntax for the DlookUp
2. Where should I put any code so that the field updates as the records are scrolled through
3. What code should I useI have been trying to solve this for ages, so any help would be really appreciated.

[maximus]

Let me get you straight you want to lookup a value in a query and display the same on a unbound textbox on a from.

Type this code on the ControlSource of your text box.

Dlookup("[SumOfFee]","qry_fees","[Picture Index]="&Forms!Name of Your Form!Picture Index)

This will solve your problem.

If your are able to solve your problem please mark this thread solved.

[Tiffer]

MaximusMany thanks. I was still having problems, until I closed the Database down and restarted. It now worksHow do I post the thread as solved?

[maximus]

https://www.accessforums.net/forum-s...lved-1828.html
Follow this link and learn how to mark this thread solved. marking threads solved wil help somebody having a similar problem later. Thanx that I could help

[maximus]

Please mark the thread solved follwo the link and learn how to do it. Basically go to thread tools and mark it solved.

Thanx