continiuse form with text Box - Data apears in every one not just one

[Simon]

I have a Continiouse from that is based on a query

I have added a new text box and a button which has the following code

DLookup("[TradePRiceExVAT]", "tblProduct", "[ProductID]=" &
Me.ProductID)

However when i click on it the value apear on every recored on the
continiouse form not just the recored i want

What causes this?

 

[fredg]

I have a Continiouse from that is based on a query

I have added a new text box and a button which has the following code

DLookup("[TradePRiceExVAT]", "tblProduct", "[ProductID]=" &
Me.ProductID)

However when i click on it the value apear on every recored on the
continiouse form not just the recored i want

What causes this?

That's correct. The control is unbound so how would Access know which
record the value belonged to. An unbound control placed on a
continuous form, is just one control, repeated for each record.
Place the control in the Form's header