Error in the table part of a Dlookup string

[Xenocide]

Hi

I'm having an error in this string

Depense2 = DLookup("Sum(Depense)", "[C:\Documents and Settings\schiasson\Bureau\bd2].[" & Me!lst3.Column(0) & "]", "Maitre= IdEngagementA AND IdEngagementA <> '01-000000-BU'")

The error is being cause by this part
"[C:\Documents and Settings\schiasson\Bureau\bd2].[" & Me!lst3.Column(0) & "]"

I know the directory is the good one cauz I used the exact same string in a select and it work.

I tried a couple of things but still have the error
can somebody help me?

 

[stomper57]

Hi,

If [" & Me!lst3.Column(0) & "]" is a string, try adding single quotes or Chr(34) - double quote.

['" & Me!lst3.Column(0) & "']"
[" & Chr(34) & Me!lst3.Column(0) & Chr(34) & "]"

Bryan