linking?

[ksawb]

I have one table. I want to pick from field one (Control Box) and have field
two show up in a (text box) I think this should be easy but a month of
trying to figure this I'm about to tell the boss to &^*((^&

HELP??

[John Spencer]

BY control box, do you mean a dropdown combobox?

If so, you can include both fields in the underlying source for the combobox
and in the text control set the control value to
=NameOfCombobox.Column(1)

Column numbers start from zero, so column one would be the second column in
the combobox's row source. If you don't want to see the second field when
you are choosing from the combobox, just set the column widths property of
the combobox to ;0. That will automatically show the first column and hide
the second column.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

"ksawb" <ks...@discussions.microsoft.com> wrote in message
news:4C386B3E-1C1A-4BEA...@microsoft.com...