Use value from unbound column in combo box?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judy Ward - 25 Jul 2005 20:28 GMT

I have a combo box, cboSAR_ID, on a form with these properties:
Row Source: SELECT SAR_ID, SAR_Link from tblSAR;
Column Count: 2
Bound Column: 1

I have one button that uses Me.cboSAR_ID to open another form.

I want another button that uses the value of SAR_Link to open a hyperlink.
If I had bound the SAR_Link column I could use:
Application.FollowHyperlink Me.cboSAR_ID & "#",,True

Is there a way to use the value of the SAR_Link from cboSAR_ID when it is
not the bound column?

Thank you,
Judy

Reply to this Message

Marshall Barton - 25 Jul 2005 21:22 GMT

>I have a combo box, cboSAR_ID, on a form with these properties:
>Row Source: SELECT SAR_ID, SAR_Link from tblSAR;
[quoted text clipped - 9 lines]
>Is there a way to use the value of the SAR_Link from cboSAR_ID when it is
>not the bound column?

You can refer to any column in a combo/list box row source
by using comboname.Column(N) where N is the zero based
column number.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Judy Ward - 25 Jul 2005 22:37 GMT

Thank you very much. This is excatly what I needed.

> >I have a combo box, cboSAR_ID, on a form with these properties:
> >Row Source: SELECT SAR_ID, SAR_Link from tblSAR;
[quoted text clipped - 13 lines]
> by using comboname.Column(N) where N is the zero based
> column number.

Reply to this Message