Getting data from a table to a form based on a value

[ahd2008]

Hi every body,

I have 2 tables the first one includes:

# ID.
# Employee's name. etc........

the other one:

# ID.
# Course. etc..................

now, I created a form for the second table and a text box which is irrelated to my database.

The problem that I want to enter the ID in the form and get his name from the first table into that text box.

Could you please help me?

[ahd2008]

Please give me a hand here I'm wating you.

[missinglinq]

The exact syntax depends on whether the Employee ID is Text or Numeric.

Where

txtEmployeeID is the field on your second form where you enter the ID

txtEmpName is the field on your second form to hold the employee's name

EmployeeTable holds employee name and ID

EmployeeName is the field in your first table

EmployeeID is field in your first table

If EmployeeID is Numeric

Private Sub txtEmployeeID_AfterUpdate()
 'EmployeeID is Numeric
 Me.txtEmpName = DLookup("EmployeeName", "EmployeeTable", "[EmployeeID] = " & Me.txtEmployeeID)
End Sub

If EmployeeID is Text

Private Sub txtEmployeeID_AfterUpdate()
''EmployeeID is Text
Me.txtEmpName = DLookup("EmployeeName", "EmployeeTable", "[EmployeeID] = '" & Me.txtEmployeeID & "'")
End Sub

Welcome to Bytes!

Linq ;0)>

[ahd2008]

Thanks genius it works.

Have a nice day.