Retrieving a value from another table in a form

[Frankie]

Hi,

I am working on a form where users can fill in an employee number. As soon
as this is done I would like to show the name of this employee in this form.
The name is stored in a different table. I think this can be done by using
an expression but I need some help on this.

Thanks a lot.

Frank

[Rick Brandt]

"Frankie" <f.*********@tiscali.nl> wrote in message
news:41**********************@dreader2.news.tiscal i.nl...

Hi,

I am working on a form where users can fill in an employee number. As soon
as this is done I would like to show the name of this employee in this form.
The name is stored in a different table. I think this can be done by using
an expression but I need some help on this.

=DLookup("EmployeeName","EmployeeTable","EmployeeN umber = " & Me.EmpNum & "")

You would of course have to substitute your actual names for the table, the
fields, and the name of the control on the form where the user entered an
employee number.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Frankie]

It's working now!

Thanks Rick.
"Rick Brandt" <ri*********@hotmail.com> schreef in bericht
news:2s*************@uni-berlin.de...

"Frankie" <f.*********@tiscali.nl> wrote in message
news:41**********************@dreader2.news.tiscal i.nl...

Hi,

I am working on a form where users can fill in an employee number. As
soon
as this is done I would like to show the name of this employee in this
form.
The name is stored in a different table. I think this can be done by
using
an expression but I need some help on this.

=DLookup("EmployeeName","EmployeeTable","EmployeeN umber = " & Me.EmpNum &
"")

You would of course have to substitute your actual names for the table,
the fields, and the name of the control on the form where the user entered
an employee number.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com