DLookup Problem

[byTimber]

Hi All,

I am trying to obtain a field value from my Access table

LVFPath = DLookup("BusinessName", "Table 1")
This works but

LVFPath = DLookup("LVFTemplate", "Table 1")
DOESN'T !!

They are both fields in the same Database Table, Table 1

Variables declared and field names are spelt exactly but No 2 attempt returns null
Can anyone please figure what is awry?
Roger ...

 

[crxftw]

Have you tried to add criteria after domain?

And why are you using same variable for different lookups?

 

[gemma-the-husky]

there definitely is somethnig amiss. how many records are there in table 1?

 

[byTimber]

Thank you crxftw - that did it!!

(And thanks for that speedy response)
Roger ..

 

[byTimber]

Gemma the Husky; Putting the criteria in sorted out the problem but thanks for your interest...
Roger