InfoPath Dev

Hello,

I have a form that has a drop-down list box attached to an SQL server secondary data source that contains customer names and addresses. When a user chooses the customer name from the drop-down list, the address, zip, etc fields auto-fills using the rules method. However, if the customer's address changes in the data source and we re-open the form, the address and other info still displays the old data. The only way to get it to update in the form is to change the drop down list to a different customer, and then change it back. I tried adding a "Refresh" button that is set to refresh all data sources, but it doesn't seem to refresh the data. Can anybody suggest a method for either getting this "refresh" button to work as I think it should, or to set the form to refresh the data each time it is opened?

Thanks,

Jason

Hi,

The address is stored in your primary DOM, right? So, even if the secondary data source did change, the changes won't automatically flow to your main DOM. You need to open your secondary DOM by code and compare data for a given Customer ID. You can do this OnLoad and/or with a Refresh button. It will involve some coding, but it is doable.

Regards,

Franck Dauché

Hi,

Thanks for the quick reply. What you describe is exactly how my form is setup. Unfortunately, I am at best a novice programmer so really have no idea how I would code this. Could you point me to any MSDN articles that would deal with a scenario like this, or any code snippets I may adopt for this purpose?

Much Appreciated,

Jason

sorry, I missed your answer there....
You can do a search for "Secondary DOM" in this forum to get some samples.

Franck