InfoPath Dev

When you set up (or modify) your SQL data connection, there is a button that allows you to modify the SQL statement. If this does not provide what you need, you can always write code behind your search button that updates the data connection query string with the correct SQL statement, and then force the query to happen.

Great! Glad when its the simple things!

Thanks Matt.

Sure. Glad to have helped.

Again, you only modify nodes and node values -- not controls. When dealing with a DDL, you are dealing with the node that the DDL control is ''bound'' to--not the control itself. Thus if you modify the value of that node that your DDL is bound to, you modify the selected value of that DDL. What you need to do is create a secondary data source ...

Glad to help!

Hello l.a.spates and Welcome to Forums, You can get Partner names into dropdown in Contribution form by having a secondary data connection to Partners DB for that follow these steps: 1. Open Contribution form in Design mode 2. Go to Tools -> Data connection, Click on Add 3. Select Receive data and click on Next 4. Select Database and ...

thanks matt

I will explain what I am trying to do in a little more detail: The field is collecting the customers name. Right now it is a dropdown list that includes the 10 of the most frequently used customer names. I need to add an optional box for other. The problem I am running into is this is connected to a SQL DB and am not able to bind both controls to ...

Thanks, I am using SQL 2005 and I have complete access to the server and database. I think I understand what is happening, when we run the the query, I think it pulls the records into the form and works with them only, so if you change the data that it has pulled back it will update the data with the amended data and not insert new rows. It makes ...