Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Auto populate Text Box

Discussion in 'Information Technology' started by Becky, Jul 28, 2006.

  1. Becky

    Becky
    Expand Collapse
    Guest

    Hi I am new at creating Access Databases and am in the process of creating
    one for work.
    Here is my situation. I have a form that I have created with various tables
    and combo boxes. We have part numbers then there are descriptions of each
    product. I have a table with all the part numbers and the description next
    to them. I want to be able to pick the part number and then have the
    description automatically populate a text box. Does anyone know how to do
    this.
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Is Autocomplete Evil? Some Women Take A Hard Look at Google ! Breaking News Nov 7, 2013
    Sikh News AutoZone sued for firing Everett Sikh Breaking News Sep 29, 2010
    India Singh: Centre Ready To Give Kashmir Autonomy Breaking News Aug 11, 2010
    India Paste tariff cards behind driver’s seat: Transport dept to automen Breaking News Jul 21, 2010
    Gursharan Kaur: India's First Lady's Autobiography Sikh Personalities Jun 1, 2010

  3. Sprinks

    Sprinks
    Expand Collapse
    Guest

    Becky,

    Include both fields in a combo box. The easiest way to do this is to use
    the wizard from form design view. To enable the wizard, choose View,
    Toolbox, and toggle on the button with the wand and stars. Then choose the
    combo box tool, place the upper left corner of the combo and drag to the
    approximate bottom right corner. The wizard will launch; follow the prompts.

    Since you wish to display the part number, which presumably is the key field
    of your RowSource table, uncheck the Hide Key Field (Recommended) box when
    prompted.

    The combo box will display both columns in the drop-down list, but will
    display only the part number after you have made a selection. If you don't
    wish to see the description in the drop-down, set the second entry of the
    ColumnWidths property to 0".

    To display the description of the selected part number in a textbox, set its
    ControlSource using the Column property of the combo box:

    = YourComboBox.Column(1)

    Hope that helps.
    Sprinks


    "Becky" wrote:

    > Hi I am new at creating Access Databases and am in the process of creating
    > one for work.
    > Here is my situation. I have a form that I have created with various tables
    > and combo boxes. We have part numbers then there are descriptions of each
    > product. I have a table with all the part numbers and the description next
    > to them. I want to be able to pick the part number and then have the
    > description automatically populate a text box. Does anyone know how to do
    > this.
    >
     
  4. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Becky,

    There are a number of ways this can be done. This article discusses
    some of them. Have a look through the examples in the article, and then
    post back if you need any more explicit help.
    http://accesstips.datamanagementsolutions.biz/lookup.htm

    --
    Steve Schapel, Microsoft Access MVP

    Becky wrote:
    > Hi I am new at creating Access Databases and am in the process of creating
    > one for work.
    > Here is my situation. I have a form that I have created with various tables
    > and combo boxes. We have part numbers then there are descriptions of each
    > product. I have a table with all the part numbers and the description next
    > to them. I want to be able to pick the part number and then have the
    > description automatically populate a text box. Does anyone know how to do
    > this.
    >
     

Share This Page