How do I display the result of a query in a textbox when criteria.

[Guest]

I have a form named activity report that takes an employee's id and activity
information for a day and inputs the data into a table called activity
report. The talbe Activity Report is connected to another table called
employees which stores the employees personal information like name and such.
What I need to do is once the employee ID is entered on the form, I need the
employees name to be displayed in another textbox to ensure that the data
entry person keyed the correct ID. Any help would be good. Thank you.

 

[Duane Hookom]

Consider finding a naming convention that doesn't use "report" in form and
table names. I would be very confused maintaining an application with names
of one type of object embedded in names of other types of objects.

You should be selecting the employee from a combo box. This ensures data
integrity. You can display other columns from combo boxes in text boxes that
have control sources like:
=cboEmployeeID.Column(1)