How Can I assign value from a table and put it on the form. The form has
EMP_ID and EMP_NAME and I want the user to put the EMP_ID and pull the
EMP_NAME from another TABLE which has EMP_ID and EMP_NAME. Any support is
appreciated.
You should certainly NOT be actually *storing* the EMP_NAME
redundantly in this form's table... you're not, are you?
I'd suggest concealing the EMP_ID altogether, unless ID's are commonly
used and meaningful outside the database. To do so, you can put a
Combo Box on the form bound to EMP_ID, based on the Employee table;
this combo can *display* the name while it *stores* the ID, keeping
both the computer and the user happy.
If the ID's are in fact meainingful to users, you can still use a
combo box; it should contain both fields. Put a textbox on the form
with a Control Source
=comboboxname.Column(n)
where comboboxname is the Name property of the combo, and (n) the
*zero based* subscript of the field that you wish to display - that
is, (1) means "the second column of the combo's row source query".
John W. Vinson[MVP]
