Hello Guys,
I am getting an error while doing Dlookup in Unbound form field, I have 2 tables where one table name "Positiondetails" which has columns i.e. "Position_Code" (Short text and primary key) and another is "Positions", another table named "Recruitment Tracker" wherein Form already created from this table and has fields Sr No (primary key Number), Position_Code (Short text), Positions(Short text), I have created relationship one to many from "Positiondetails" table Position_code to "Recruitment Tracker" Position_Code to get drop down in form.
Postion_code field named as PC1 in form
However, when I directly did the Dlookup in Positions field (Form) control source it is not working or an Error.
please help me with this, dont know what i am doing wrong here or let me know if any other method to do lookup in existing form
=Dlookup("Positions","Positiondetails","Postion_co de=' " & [PC1] & " ' ")