Lookup function????

[phd4212]

Hi All,


I have a table (Equipment_Age) that has Age in the 1st column and Resale_Percentage in the second. I'm developing where the user inputs their car's age and I want it to populate a second box that lists the resale percentage.

For example if the car was built in 2010 it would reference the Equipment_Age table and for Age = 2 it would return a percentage of X%

I think this is a dlookup function, but I'm getting confused on syntax

Thanks in advance!

[ketbdnetbp]

phd4212 -

You could try the following in an unbound textbox control's controlsource property on the same form as the input age textbox -

=DLookup("[Resale_Percentage]","[Equipment_Age]","[Age]=" & [forms]![yourformname]![inputagetextboxname])

Hope it helps,

Jim