Text box display

A

Allan Murphy

Dave

Create an unbound text box to hold the staff name. Hide your staffid field,
then use Dlookup to lookup your staff name using the staffid
 
D

David

Hi,
I have an access form for which I use as a gerneral display of what is
in table. The table contains a field with numbers which are ID's for
another table (a staff list). When I open the form and use a combo to
select the record I would like the text field to display not the ID but
a staff name that the ID refers to.

Any help is appreciated!

Thanks,
David
 
A

Allan Murphy

David

Assuming your combo box displays ID and staff name

In the properties of the combo box set the column width of your first colum
to 0;x
Where zero is used to "hide' the column but still use it the program and x
is the value to display the full name etc.
 
D

David

The combo box is used to select a project, each of are linked to a
staff members table. I would like to display the staff name in the
view project form instead of the staff ID that I use to link it.
Thanks!
Dave
 
Top