Dlookup returns #Error 1

[BobJacksonNCI]

I've used Dlookup before and never had trouble like this...

Working on an .ADP with Access 2000 front, SQL 7 back.

Report control contains:
=DLookUp("[CostCenter]","MgrTB_tlkpCostCenter","[Dept] = " & [Forms]![frm_TIME_OFF]![txtDept])

The form is open with data loaded.
Fields are text (char).

And it STILL returns #Error in the control when I
execute the report. Tried adding the table name in
front of [Dept] in case there is another [Dept]...
Also added dbo. in front of the table - nope.

Should be easy, but isn't so far.

Assistance IS appreciated!

 

[jrbarnett]

Is txtDept a string value? If so, use:

=DLookUp("[CostCenter]","MgrTB_tlkpCostCenter","[Dept] = '" & [Forms]![frm_TIME_OFF]![txtDept] & "'&quot

John

 

[BobJacksonNCI]

Thanks, John.

Let's see, 8.07532913 seconds for your "ON THE BUTTON" reply!

Certainly worthy of a star!

(Yeah, experts reading this, it wasn't that tough a question. But, I'm sure there are many of us Access
novices who are going nuts with online help and manuals.
- I have 6, so far. This kind of assistance DOES bear recognition!)