dlookup多个表并将文本框设置为结果访问2007

I'll try and break down my problem as best I can and explain what I'm trying to achieve. Firstly, I have three tables:I'll try and break down my problem as best I ca