Set Control Source of Text Box to Second Column in a Combo Box

Discussion in 'Microsoft Access Forms' started by garethg, Mar 3, 2004.

  1. garethg

    garethg Guest

    How do I set the Control Source of my Text Box to the Second Column in
    Combo Box

    -----------------------------------------------

     
    garethg, Mar 3, 2004
    #1
    1. Advertisements

  2. garethg

    '69 Camaro Guest

    Column numbering starts at zero, so in the Control Source Property of your
    text box try:

    =cboAmount.Column(1)

    where "cboAmount" is the name of the combo box on the current form.

    HTH.
    Gunny

    Coming soon:
    For your Microsoft Access, database development and maintenance needs, see:
    http://www.softomagixly.com

    "garethg" <> wrote in message
    news:...
    >
    > How do I set the Control Source of my Text Box to the Second Column in a
    > Combo Box?
    >
    >
    > ------------------------------------------------
    >
    >
    >
     
    '69 Camaro, Mar 4, 2004
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.