Hi
What I am trying to do is make the inputted string into a text box called "Stage" be searched for in a table called "FIN_Routes".
The criteria is that the FIN needs to match what is in the "FIN" box. Both the "Stage" and "FIN" box are in the "Inspection_records" form.
The expression that I have come up with is:
=DLookUp("'" & [Forms]![Inspection_records]![Stage] & "'","[FIN_Routes]","FIN='" & [Forms]![Inspection_records]![FIN] & "'")
After trying this and various other versions all I get is #Error in the box.
I am new to access so I don't see where I am going wrong?
Thanks