Referencing field

  • Thread starter Thread starter Frank B
  • Start date Start date
F

Frank B

You did not say if the table has more than one record. If
there is only 1 record, then..
Dim N$
Dlookup("TPA_Name_f","Labels")

If there is more than 1 record in Labels, then you will
need to use the 3rd argument of the Dlookup function which
is a "Where" clause. In that clause you must tell access
how to find exactly the record you are looking for:
eg.
X$ = "Jones"
the WHERE clause would look like: "ClientName='" & X$
& "'"

Then, of course, where you have "\" & "Tally.xls",
change it to "\" & N$ & "Tally.xls",

Hope that helps.... Frank
 
Thanks! That worked!
-----Original Message-----
You did not say if the table has more than one record. If
there is only 1 record, then..
Dim N$
Dlookup("TPA_Name_f","Labels")

If there is more than 1 record in Labels, then you will
need to use the 3rd argument of the Dlookup function which
is a "Where" clause. In that clause you must tell access
how to find exactly the record you are looking for:
eg.
X$ = "Jones"
the WHERE clause would look like: "ClientName='" & X$
& "'"

Then, of course, where you have "\" & "Tally.xls",
change it to "\" & N$ & "Tally.xls",

Hope that helps.... Frank



.
Click to expand...
 
Back
Top