I have created form with a button in it.Here is the scenario:
This form contains 2 kind of fields: fields that contains key for query data (e.g. employeeID) and also fields for query-result data (e.g. employeeAddress).
There will be 2 parties, A and B. Party A will send the form with particular employeeID to the party B.
Party B opens the form. When the button clicked by party B, it will connect to MYOB database at party B (using ADODB connection and VSTA), get some needed data (employeeAddress), and display it in the same form.
And Party B will send the form back to party A.
Now I want to distribute the form, is it possible to distribute the form (which contains custom code) by email from Party A to Party B, and also from Party B to Party A? ( As I read in
http://office.microsoft.com/en-us/infopath/HP100997611033.aspx template can't contain data connection)