Code

Re: Filling combo box items manually in a repeating grid

jbobish — Thu, 06 Nov 2008 22:13:48 GMT

Thanks guys, I believe this will work though I haven't implemented it yet. I don't mind manually creating and changing the data source nodes in code now that I know that's how it must be done.

Re: Filling combo box items manually in a repeating grid

Jimmy — Thu, 06 Nov 2008 13:57:11 GMT

I'm not 100% sure that the following would work on a browser-enabled form, but I have tried it on a regular form, and it works.

Create a dummy XML file to use as a data source for the second dropdown box; something like:

<?xml version="1.0">
<dropdownEntries>
<entry value="" display=""/>
<entry value="" display=""/>
</dropdownEntries>

Then in the OnAfterChange event of the field bound to the first dropdown box, perform the following in code:

Remove all entry nodes from <dropdownEntries>
Add new nodes to <dropdownEntries> accordingly, based on the new selected value in the first dropdown box.

If you would like an example of how to perform this in code (it's fairly simple), I'd be happy to provide it to you.

Re: Filling combo box items manually in a repeating grid

Shiva — Thu, 06 Nov 2008 12:05:11 GMT

Hello,

If you enter dropdown values by manually for dropdown then we don't have option to filter those for second dropdown. For these you have to prepare one secondary xml file and take the connection as resource file or data connection.

Go through the below link once,

http://www.infopathdev.com/forums/p/6064/22601.aspx#22601

Filling combo box items manually in a repeating grid

jbobish — Mon, 03 Nov 2008 18:30:41 GMT

I'm working on a form that will have a set of repeating rows. In each row are two columns, each containing a dropdown listbox. Selecting a value in the first dropdown will determine what items are available to be selected in the second dropdown. All values come from a SQL Server database query.

I need the form to be browser enabled and I believe that excludes me from using data source filters to accomplish this.

In non-infopath C# I would just manually fill both dropdowns with values and have the on_changed event of the first dropdown contain code to populate the second dropdown. I haven't been able to figure out how to do this within infopath. Do any of you have any ideas?

Thanks!