Populate A DropDown - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Populate A DropDown

Last post 03-02-2010 06:43 PM by Jimmy. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 08-24-2004 11:36 AM

    • Wallen
    • Not Ranked
    • Joined on 08-24-2004
    • USA
    • Posts 3

    Populate A DropDown

    Greetings.
    I am trying to populate a dropdown from data that is returned from an ADO connection. I have read and downloaded the "fully editiable Dropdown example. I was completely lost. (New to InfoPath) Is there a simple way to insert information into a dropdown?


    Thanks

    Bill
  • 08-25-2004 12:10 PM In reply to

    The example you refer to is quite complex and for advanced uses. It sounds like all you are looking to do is populate a drop-down list from a secondary data source. This is not too hard.

    1. Double-click on the drop-down list box in the view.
    2. In the Drop-Down List Box Properties dialog box, select Look Up Values In A Data Connection...
    3. Select your ADO data connection.
    4. Click the Select XPath button to the right of the Entries text box and choose the repeating field you want to use as the options in your drop-down list.
    5. If your chose repeating field will not be used as both the name and value in the drop-down list, update the Value and Display Name.
    6. Click OK and preview your form.

    Greg Collins [InfoPath MVP]
  • 03-02-2010 11:59 AM In reply to

    • g21cincy
    • Top 150 Contributor
    • Joined on 10-20-2008
    • Cincinnati, OH
    • Posts 64

    Greg,

    I'm trying to populate 4 drop down lists with the same group of names. I'm guessing I'll just have to use the same solution 4 different times for each variable name. Below is an example of what I'm trying to do. Keep in mind that the first part of where they fill in their first name and last name in separate text fields is on the page before the drop-down list boxes. The user can save the data on each page. Any help on this would be greatly appreciated. I was told that I might have to create a secondary data source and programmatically add/remove items to the data source. I'm not really sure how to do that though. 

    Example:

    These are 5 rows a user can fill out with separate boxes for the first and last names.

    First Name1                        Last Name1

    First Name2                        Last Name2

    First Name3                        Last Name3

    First Name4                        Last Name4

    First Name5                        Last Name5

    On the next page they want these names to be populated in a drop down list as follows (the First Name and Last Name are concatenated together):

    First Name1 Last Name1

    First Name2 Last Name2

    First Name3 Last Name3

    First Name4 Last Name4

    First Name5 Last Name5

  • 03-02-2010 06:43 PM In reply to

     I have responded to g21cincy's question in:

    http://www.infopathdev.com/forums/p/14724/52364.aspx#52364

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.