Acc97
on a subform I have a series of Combo box's which because of my
inability to think ahead! I have had to use a field on the last one
which I did not intend to use, and bound to it. Therefore, I have a
two column drop down with the first field showing a Ref No. but the
second column showing me what I really want but I can't tap into it "
So near yet so far"
What I want to do is see on the form the second column in a separate
text box but how I extrapolate this just eludes me!!
Within the SQL I see the field I want but I just can't seem to get to
it! using a text box.
I have tried to use DLookup but this has proven to be easier said than
done!! and I still have not sussed it out on how to do it using three
items..
Appreciate any help...
Thanks..