By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,106 Members | 2,679 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,106 IT Pros & Developers. It's quick & easy.

Tapping into 2nd unbound Combo colum

P: n/a
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..
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can refer to the other columns in a combo box as
Me.cboMyCombo.Column(n), where n is the column number (starting with column
0)

In the AfterUpdate event of your combo box, put something like:

Me.txtMyTextField = Me.cboMyCombo.Column(1)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Alex" <ge****@yas1.freeserve.co.uk> wrote in message
news:b7**************************@posting.google.c om...
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..

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.