DLookup

  • Thread starter Thread starter GLT
  • Start date Start date
G

GLT

Hi,

I have the following line in VBA code:

strPath = Dir$(DLookup("fldImportDirectory", "tbl00_dbSettings"))

If I hover my mouse over the above during a debug, then strPath = the
correct path. However when I run the above, and display strPath in a message
box, its blank.

I am trying to get strPath to equial a value stored in a table.

Can anyone advise the correct way to get the above working?

Any assistance is always greatly appreciated...

Cheers,
GLT.
 
Back
Top