Hi
I have a query that accepts a parameter from form that is not working. See following :
So the first obvious thing is that I have tried to get the Selected value from the Combobox into a Textbox which gives me the ID rather than the actual Dept Code (PT-24).
Hence this is why the query is not working. when I hard code the value ="PT-24" into the Query criteria this works fine.
I am clearly missing something here.
I am using the following for syntax which I have looked up in many tutorials and is supposed to work.
[Forms]![Frm Run Starter Leaver Query]![cboSelectedPtSubDept]
Any assistance would be appreciated. Thanks in advance.