Dlookup #Error - it boggles my mind 1

[cutestuff]

hi,

I am not sure as to why this error is happening, since I've used Dlookup before and it hasn't given me any problems.

I have a query called qryTotalVPFiles which counts how many VP files there are.
In my form, I have a textbox that uses the Dlookup to display this total.
The controlsource for this textbox is as follows:

=DLookUp("Total VP Files","qryTotalVPFiles")

Sometimes this works, but most of the time it's been giving me a "#Error" in the textbox. Why is this so? Why does it work sometimes and not other times? When I first set it up, it worked fine.

It boggles my mind.
Please help.

Thank you in advance.

 

[RuralGuy]

Access does *not* like embedded spaces in a name.
Try: =DLookUp("[Total VP Files]","qryTotalVPFiles")

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit

 

[cutestuff]

hi RuralGuy,

Thanks for the input.
I've solved the problem though. I had a csv file that I guess needed to be relinked. It was very weird.

Thanks again.