Table Field Lookup Value based on ther Column Field

[ilcaa72]

With a Table I want to do I lookup based on the value of another field, exactly like a Vlookup in Excel. I am trying the DLookup but dont know if this is what i need.

Here is a visual (attachment) to help understand what i need. This is the DLookup()

DLookUp([tblAnswers]![AnswerNumber], [tblAnswers], [ResponseTracker]![QuestionID])

 

[pbaldy]

I would use this method:

http://www.baldyweb.com/Autofill.htm

If you want to use the DLookup(), there are issues with your syntax:

http://www.theaccessweb.com/general/gen0018.htm

 

[Wehbyj]

Try this syntax :
DLookUp("AnswerNumber","tblAnswers","QuestionID=" & [ResponseTracker]![QuestionID])