Thank you for suggestion!
I tried to use your suggestion and I don't think my first post was
clear enough.
Bare with me and I'll try again.
I have a form I want to be a view only form. This equipment table has
several fields that the values are lookups from other tables. An
example is the Owner field is a lookup field based on the Employee
table it is bound to the employee number but displays the name. When
I created the form for Equipment table the field "Owner" is displayed
as a Combo box and I want to convert it to a text field. When I do
this it will only display the Employee ID and not the name.
Please let me know if you have any other suggestions.
On Thu, 15 Apr 2004 22:22:22 +0200, Hans-Joerg Karpenstein
<hj***********@web.de> wrote:
Am Thu, 15 Apr 2004 13:06:04 -0400 schrieb N.Graves:
Hello;
I have a table that is equipment. This table has a filed called Owner
and that Owner filed is Looked up from a table called employee. and
the query request the serial number of the employee and his/her name.
I have this field bound to the serial number but it displays the name
in a data sheet. Works great,
My problem is I have a form that I want to be used as display and
informational but not data entry or editing. I would like to display
the employees name on it but when I change the combo box to a text
field it shows the employee number.
Hello,
try
=Dlookup("persontable","namefield","id=" & combobox
as recordsource property of the field
HTH
Karpi
<fluctuat nec mergitur>