And since this is a learning exercise, a couple of things:
First, Bob's syntax is correct if 'EmployeeNumber' is defined as a Number Datatype, which your initial post would seem to suggest.
But if 'EmployeeNumber' were to be defined as a Text Datatype, the correct syntax would be
Code:
=DLookUp("FirstName","Employees","[EmployeeNumber] ='" & [EmployeeNumber] & "'")
Secondly, that 'digits' and 'numbers' should not be confused. Data like Employee Numbers, Serial Numbers, Social Security Numbers, etc., when only containing digits, can be defined as Text or Number Datatypes. Which you elect to use is up to you. The rule of thumb that I use is that if the data will not be used in performing math, it's Text, otherwise, it's a Number. But that's an individual decision. The only I'd define a non-math, all-digits Field as a Number would be if it were to be used as a Primary Key.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007