Continuos form with calculated field for Data entry

[todmac]

Hello All,
I have a continuous form, linked to a table. The user opens the form and enters as many records as required (always different amounts depending on the report being entered).
Recently a request was put in. The request is that when the user enters the claim number and the amount to be paid that they can see how much the original claim amount was for.
This value is in a different table. I was able to use a calculated field to produce it however because it assigns the value to an unbound field it appeared in every record the user tried to input (needs to be unique to each claim number).


I have not been able to find an expression that I can put in the actual table (Doesn't allow Dlookup) and when I try and base it on a query it is no longer a continuous form and seems to be locked for editing.
Any thoughts on the best way to do this are greatly appreciated.
Todd

[Missinglinq]

...I was able to use a calculated field to produce it however because it assigns the value to an unbound field it appeared in every record the user tried to input (needs to be unique to each claim number)...

Instead of assigning it, as you are now doing, to make the Unbound Control be Record-appropriate, you need to place your Calculation in the ControlSource Property of the Unbound Textbox, preceding it with the Equal Sign.

Linq ;0)>