DLookup Problem With Adding A Variable

[FontanaS]

Have the following code in the record source for a field on a report -


=DLookUp("[Question]","Qry_Questions","[QuestionNumber] = [reports]![Rpt_Individual_NonSupervisor_Only].[TestVar]")

example for the varaible above -
[reports]![Rpt_Individual_NonSupervisor_Only].[TestVar] = A1

I keep getting an #error. it is a text field that i assign in the open event (based on what the user enters on another report)

THANKS!

 

[jrbarnett]

That occurs because you are trying to compare two fields to each other. Try this instead:

=DLookUp("[Question]","Qry_Questions","[QuestionNumber] = '" & [reports]![Rpt_Individual_NonSupervisor_Only].[TestVar] & "'")

John

 

[CosmoKramer]

Try 'single quotes' around the [TestVar] control:

=DLookUp("[Question]","Qry_Questions","[QuestionNumber] = [COLOR=red]'" [/color]& [reports]![Rpt_Individual_NonSupervisor_Only].[TestVar][COLOR=red] & "'"[/color])

Hoc nomen meum verum non est.

 

[FontanaS]

THANKS!
Now i am getting the #Name? error.
When I assign the variable i have the following -

testvar = Forms!Frm_Criteria_Selection.txtQuestionChoices

Do i need quotes around that too?