displaying information in continuous forms

[scottmech]

if i use a continuous form and i want to display employee name in a text box, without using a combo box because of the damn drop down arrow, what should i do. the problem i am having is that i need to do a lookup in employees table. in a combo box, i can retrieve the employeeID number & join first and last naem and set column width to 0". what can i do to show this similarly on a continuous form, since i dont want a drop down arrow to appear. the data on this subform will NOT be edited in the subform.

TIA,
Scott Mech

 

[ElsVanMiert]

You could simply use a query instead of a table as recordsource for your form.

Simply create a new field in this query like follows:
FullName: [Name] & "," & [FirstName]

and display it on your form.