Dlookup based on a Text field?

  • Thread starter Thread starter Charess
  • Start date Start date
C

Charess

I have a form called frmEmployee Details, in which I would like to have the
details populate off of employee name(this will include their first & last
name) which is included in a table that has all the employee details called
tblEmployee_Lookup. When I try this with the following formula I get an error:

=DLookUp("[Big6]","tblEmployee_Lookup","[Name]= " &
Forms!frmEmployee_Details!Name)

However, when I based the formula on the employee id number it works. I know
that it is better to use a unique number than name, but this database is for
a particular set of users that need to have it be based off the employee's
name. Any advice?

Thank you.
Charess
 
Since the Name field is a text data type you need to use
quote delimiters in the DLookup;

=DLookUp("[Big6]","tblEmployee_Lookup","[Name]= """ &
Forms!frmEmployee_Details!Name & """")

For clarity, that's three double quotes after "[Name]= and
four double quotes before the closing parentheses.
 
Sean,

In addition to what Beetle said it should be noted the *Name* is a Reserved
Word in Access. You should avoid using those because Access will become
confused. For a complete list see...

http://allenbrowne.com/AppIssueBadWord.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Beetle said:
Since the Name field is a text data type you need to use
quote delimiters in the DLookup;

=DLookUp("[Big6]","tblEmployee_Lookup","[Name]= """ &
Forms!frmEmployee_Details!Name & """")

For clarity, that's three double quotes after "[Name]= and
four double quotes before the closing parentheses.

--
_________

Sean Bailey


Charess said:
I have a form called frmEmployee Details, in which I would like to have
the
details populate off of employee name(this will include their first &
last
name) which is included in a table that has all the employee details
called
tblEmployee_Lookup. When I try this with the following formula I get an
error:

=DLookUp("[Big6]","tblEmployee_Lookup","[Name]= " &
Forms!frmEmployee_Details!Name)

However, when I based the formula on the employee id number it works. I
know
that it is better to use a unique number than name, but this database is
for
a particular set of users that need to have it be based off the
employee's
name. Any advice?

Thank you.
Charess
Click to expand...
Click to expand...
 
Back
Top