Employee "Login", Lookup and display name from number

[gavm360]

Hello,

I'm making a data entry form that i would like to have display the
operators name.

So far i have a preceeding "Login" form in which the operator inputs
his/her employee number into a text box "txtopnumbe r".

They then click a button which sets the value:

Private Sub Command2_Click( )
gopnumber = Me!txtopnumber

Then i create a module to return that value:

Public Function getopnumber() As String
getopnumber = gopnumber

So on the data entry form i have just been calling up the value by
putting
getopnumber() as the control source.

My question is, I would like the operators to input his/her employee
number in the login form and have somethat looks up the employees name
and displays that on the data entry form. (Instead of just inputting a
number and displaying the number elsewhere I'd like to input a number
and display the associated name elsewhere)

Thanks for your help!
Gavin

[Patrick A]

Gavin,

I think you're working too hard...

If you have a table "Emps" containing the "EmpID" and "EmpName", and
your form has the "EmpID" in "TB_EmpID" and the "EmpName" in
"TB_EmpName ", the following code in in the AfterUpdate event of
"TB_EmpID" should do what you want.

Private Sub TB_EmpID_AfterU pdate()
Me.EmpName = DLookup("EmpNam e", "TBL_Emps", "EmpID = '" &
Me.TB_EmpID & "'")
End Sub

I'm not sure if you've got the ID and the Name on the same form or
different forms, so I will leave the exact "addressing " syntax up to
you.

Good luck.

Patrick

On Sep 19, 11:18 am, gavm...@yahoo.c om wrote:

Hello,

I'm making a data entry form that i would like to have display the
operators name.

So far i have a preceeding "Login" form in which the operator inputs
his/her employee number into a text box "txtopnumbe r".

They then click a button which sets the value:

Private Sub Command2_Click( )
gopnumber = Me!txtopnumber

Then i create a module to return that value:

Public Function getopnumber() As String
getopnumber = gopnumber

So on the data entry form i have just been calling up the value by
putting
getopnumber() as the control source.

My question is, I would like the operators to input his/her employee
number in the login form and have somethat looks up the employees name
and displays that on the data entry form. (Instead of just inputting a
number and displaying the number elsewhere I'd like to input a number
and display the associated name elsewhere)

Thanks for your help!
Gavin

[Tom van Stiphout]

On Wed, 19 Sep 2007 15:18:03 -0000, ga*****@yahoo.c om wrote:

Something like:
DLookup("EmplNa me", "tblEmploye es", "OpNumber=" & getopnumber())

-Tom.

>Hello,

I'm making a data entry form that i would like to have display the
operators name.

So far i have a preceeding "Login" form in which the operator inputs
his/her employee number into a text box "txtopnumbe r".

They then click a button which sets the value:

Private Sub Command2_Click( )
gopnumber = Me!txtopnumber

Then i create a module to return that value:

Public Function getopnumber() As String
getopnumber = gopnumber

So on the data entry form i have just been calling up the value by
putting
getopnumber( ) as the control source.

My question is, I would like the operators to input his/her employee
number in the login form and have somethat looks up the employees name
and displays that on the data entry form. (Instead of just inputting a
number and displaying the number elsewhere I'd like to input a number
and display the associated name elsewhere)

Thanks for your help!
Gavin

[gavm360]

guys, these worked. Thanks!