Hi everyone!
I am creating a simple module where I want to get the data from a table (it has just one field and one record) in order to fill a variable from a module
At the beginning I want to use Dlookup but it doesn't work, I don't know if the reason is that Dlookup needs a criteria
My table is named [root_tbl] and the field is named [root] (it basically contains the root to record attached files for the app "C:\Users\name\Desktop\Foldername"
This is my code... I highly appreciate ideas how to correct this...
'*************************************************
Function Ruta() As String
'Create the root where all the documents attached will be sent
'Ruta = "C:\Users\name\Desktop\Foldername"
'The idea is to change the root directly from the table and not to get in to the module to change the code
Ruta = DLookup("[Root]", "[root_tbl]")
'I only want that the variable takes the unique information that it's contained on the field
End Function
'***************************************
Thanks in advance!