Help with DLookup

[Ayo]

I am trying to use the Expression below but I am getting a "#Error", any
ideas what I am doing wrong?
Thanks
Ayo

=DLookUp("[Type]","Actuals","[Project Number] =" & [Forms]![Form1]![Project
Number])

 

[Clifford Bass]

Hi Ayo,

Is [Project Number] a numeric or text field? Where are you using this
function?

Clifford Bass

 

[Ayo]

[Project Number] is a text field. I am using the function in the Control
Source of a TextBox

Hi Ayo,

Is [Project Number] a numeric or text field? Where are you using this
function?

Clifford Bass

I am trying to use the Expression below but I am getting a "#Error", any
ideas what I am doing wrong?
Thanks
Ayo

=DLookUp("[Type]","Actuals","[Project Number] =" & [Forms]![Form1]![Project
Number])

 

[Clifford Bass]

Hi Ayo,

Ah, that is the issue. For text fields you need to make sure you quote
the text.

=DLookUp("[Type]","Actuals","[Project Number] = """ &
[Forms]![Form1]![Project Number] & """")

Or, if there is any chance that a quote symbol could occur in [Project
Number], you will need to make sure those are doubled-up also:

=DLookUp("[Type]","Actuals","[Project Number] = """ &
Replace([Forms]![Form1]![Project Number], """", """""") & """")

Hopefully that will do it,

Clifford Bass

 

[Ayo]

Thanks Clifford. I completely forgot abot that. It works great now.

Hi Ayo,

Ah, that is the issue. For text fields you need to make sure you quote
the text.

=DLookUp("[Type]","Actuals","[Project Number] = """ &
[Forms]![Form1]![Project Number] & """")

Or, if there is any chance that a quote symbol could occur in [Project
Number], you will need to make sure those are doubled-up also:

=DLookUp("[Type]","Actuals","[Project Number] = """ &
Replace([Forms]![Form1]![Project Number], """", """""") & """")

Hopefully that will do it,

Clifford Bass

[Project Number] is a text field. I am using the function in the Control
Source of a TextBox

 

[Clifford Bass]

Hi Ayo,

Great! You are welcome.

Clifford Bass