InfoPath Dev

I have a button that executes 3 functions, Save, Print, and Submit. Several fields in my form (Rich Text boxes) are not submitted to my SQL DB and are only saved in the XML. If the user just updates these fields and clicks the button, an error message appears stating that the form cannot submit because no new data has been entered or changed. ...

I am trying to switch views based on a Queried value using VBScript. The following is my Script followed by the error message I get when I try to Preview the form. Script Sub XDocument_OnSwitchView(eventObj) Ifhttp://d:Person/@cd_Sex = ''M'' Then, XDocument.View.SwitchView(MaleExam)Or Ifhttp://d:Person/@cd_Sex = ''F'' Then, ...

I changed the data type in my DB tables to reflect boolean (tinyint or bit) and got things to work. Just figured it out this morning...thanks Agni. Smitty

I have Check Boxes as well as Option Buttons which submit values to an SQL DB but when the values are queried, the check boxes and option buttons are blank. Any thoughts? Thanks Smitty

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 ...

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 ...

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

Is it possible to pass a value from one form to another without using code? Form 1 uses 2 values to query for a specific record while form 2 uses 1 value to query for a broader range of results. I want to use one of the values on form 1 to query results on form 2. Thanks Smitty

PS...one more question Do the Tables (med, lab, rad) need to be part of the main connection or are they a secondary connection?

Thanks Agni, 2 questions: 1. Do I map everything from DDL1 using Rules? 2. How should I set the properties on DDL2? I'll play with this for awhile and see what I come up with. Thanks Smitty