get a value from another table in a form as part of a calculated field

[jgoodman00]

Hi,
Does anyone know how to extract a value from another table As it stands, I am creating a form called frmTree, which needs to take a value from tblAdopt & multiply it to produce a calculated field. I tried referencing it in as =[tblAdopt]![Track]*1, but it simply returns !NAME?. I am guessing it is because the fields need to be bound together. This is a slight problem because the two fields are related through another table....I think it needs some SQL to make it work, but I am not sure exactly what is needed...

 

[braindead2]

If I understandd what you are trying to do then dlookup is the way to go. Help give a good explaination on its use. Good luck