InfoPath Dev

I have an InfoPath form that I have two buttons on: one that submits to Access and automatically closes and one button that submits to Access and then I want it to open the same blank form that was just submitted. I am using VBA for both buttons so I an looking for the VBA that will open the blank .xsn form that is stored in a network ...

I figured it out. All I was missing was the database connection within each section. I had the connection set up in the Insert section, but not in the Update section :( Now everything is working correctly :) Thanks for your help.

I added the @ sign before the parameter names as below and still nothing is being updated in the tested_parts table.  When I add a break to stop the code when running the form such that the code should pass through the UPDATE section all the values (lab_num_tp, alloy_spec, last_tested, index_tp) are holding the correct values from ...

I have two main tables that I am entering data into and need to be able to update a record set if one exists for a part number/supplier combination. I have the code working to correctly populate the tested_parts table when a record does not already exist, but can not get the tested_parts table to update when a record does exist. I have a ...

I have two main tables that I am entering data into and need to be able to update a record set if one exists for a part number/supplier combination. I have the code working to correctly populate the tested_parts table when a record does not already exist, but can not get the tested_parts table to update when a record does exist.  I have a ...

Worked like a champ. Thanks for your help!

part_num_tp = mainDS.SelectSingleNode( _ "/dfs:myFields/dfs:dataFields/d:lab_log/d:tested_parts/@part_num_tp",

I have two MS Access tables that comprise the Infopath Main Connection datasource. The lab_log table is the parent table and all data is inserted into that table. The second table tested_parts is related to the lab_log table by lab_num and is an optional section on the infopath form. Data is entered in both sections on the form and the VBA ...

Background: I have two database tables, one is lab_entry and the second is tested_parts. Every job is submitted to the lab_entry database. I have an optional section in my form that submits to a tested_parts database that we can select when an annual test is performed. I am trying to create a submit button in infopath that queries a main ...