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

  • Thread starter Thread starter Simon
  • Start date Start date
S

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?
 
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?
Click to expand...

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
 
Back
Top