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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mario#1 - 28 Jul 2006 16:48 GMT

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.

Reply to this Message

Duane Hookom - 28 Jul 2006 16:56 GMT

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)

Signature

Duane Hookom
MS Access MVP

>I have a form named activity report that takes an employee's id and
>activity
[quoted text clipped - 6 lines]
> 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.

Reply to this Message