Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box Wizardry (Access 97)

    Hello there! I was wondering, if you make a combo box (lets say you use it to select a product name), how do you get Access to automatically populate another field (such as a product description)? (I wish I could post a screen shot to show you what I mean) Thank you!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo Box Wizardry (Access 97)

    Say that you have a table tblProducts like this:

    <table border=1><td align=center>ProductID</td><td align=center>ProductName</td><td align=center>ProductDescription</td><td align=right>1</td><td>Cheddar</td><td>Mature English cheese</td><td align=right>2</td><td>Camembert</td><td>French cheese from Normandy</td><td align=right>3</td><td>Parmigiano</td><td>Italian cheese to be grated over pasta</td></table>
    This table is the row source of your combo box. Set its Column Count property to 3, and its Column Widths property to 0";1";0".
    Let's say the combo box is named cboProduct. Create a text box with the following control source:

    =[cboProduct]![Column](2)

    The columns are counted starting at 0, so Column(2) refers to the 3rd column, i.e. the description.

  3. #3
    New Lounger
    Join Date
    Nov 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box Wizardry (Access 97)

    Thank you Hans!

    FYI, my co-worker, Ron, has told me repeatedly what a tremendous help you personally have been to him. Now I know what he was talking about! =)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •