lookups and columns

  • Thread starter Thread starter David Cleland
  • Start date Start date
D

David Cleland

hi I posted about this a few weeks back but have no idea. I have a lookup
field on a form and I want to carry out a calculation based on the value of
another field multiplied by the value in the look up - but it is the value
of the second field.

eg the look up is item eg boat I can see the word boat and a second column
called cost. I want to carry out the calculation of the cost not the word if
that makes sense ?


David
 
David,

[ComboName].Column(1) will return the value in the second column (the first
column is index 0).

HTH,
Nikos
 
Back
Top