InfoPath Dev

I have a form that is used to submit and query infromation from SQL. The user fills out the form, submits data, and closes. when the form is reopened and the information is queryed back none of the drop-downs, option buttons, or check boxes display data. Any help will be greatly appreciated.

Thanks
Smitty

hi Smitty,
When you submit the data to DB, did you see whether data is submitted to DB or not?

Please explain your problem with some more details.



Agni
InfoPath Dev India

Yes, I checked the DB and the data was there. I found a work around for the Drop Down Lists...not fun but got it to work.

Basically if I check a Check Box and the value is "1" if checked then "1" is submitted to the DB. However, when I reopen the form(form queries OnLoad) the check box is not checked. The same problem is happening with Option Buttons.

PS

The issue with the Drop Down Lists are the same. The DDL's are populated manually, when a selection is made and it is submitted to the DB I have no problem. When the form is reopened and queries the data back, the DDL is not filled in. I had to create a DB table with all the DDL values and populate the DDL's via a data connection in order for the data to be displayed when the form is reopened.