Ajax,
I was able to get all forms/subform/subsubform controls identified with the code I put together last night.
Code:
The following are the results of sub testActive
to review forms and controls
Main/Sub Form ControlName ControlType
MainControl(0) FormTestAudit TabCtl0 123 TabControl
MainControl(1) FormTestAudit Employee 124 Page
MainControl(2) FormTestAudit EmployeeId 109 TextBox
MainControl(3) FormTestAudit Label3 100 Label
MainControl(4) FormTestAudit LastName 109 TextBox
MainControl(5) FormTestAudit Label4 100 Label
MainControl(6) FormTestAudit FirstName 109 TextBox
MainControl(7) FormTestAudit Label5 100 Label
MainControl(8) FormTestAudit Gender 109 TextBox
MainControl(9) FormTestAudit Label6 100 Label
MainControl(10) FormTestAudit Title 109 TextBox
MainControl(11) FormTestAudit Label7 100 Label
MainControl(12) FormTestAudit HrlyRate 109 TextBox
MainControl(13) FormTestAudit Label8 100 Label
MainControl(14) FormTestAudit DepartmentId 109 TextBox
MainControl(15) FormTestAudit Label9 100 Label
MainControl(16) FormTestAudit Department 124 Page
MainControl(17) FormTestAudit frmDepartmentSubform 112 SubForm
-Subform name(1) frmDepartmentSubform
SubControl(1) DepartmentID controlType 109 TextBox
SubControl(2) DepartmentID_Label controlType 100 Label
SubControl(3) Department controlType 109 TextBox
SubControl(4) Department_Label controlType 100 Label
SubControl(5) CostCenter controlType 109 TextBox
SubControl(6) CostCenter_Label controlType 100 Label
MainControl(18) FormTestAudit Cafeteria Items 124 Page
MainControl(19) FormTestAudit FrmOrderSubform 112 SubForm
-Subform name(2) FrmOrderSubform
SubControl(1) EmployeeID controlType 109 TextBox
SubControl(2) EmployeeID_Label controlType 100 Label
SubControl(3) OrderID controlType 109 TextBox
SubControl(4) OrderID_Label controlType 100 Label
SubControl(5) OrderDate controlType 109 TextBox
SubControl(6) OrderDate_Label controlType 100 Label
SubControl(7) frmOrderSubSubform controlType 112 SubForm
---SubSubForm name (1) frmOrderSubSubform
SubSubControl(1) EmployeeID controlType 112 TextBox
SubSubControl(2) EmployeeID_Label controlType 112 Label
SubSubControl(3) OrderID controlType 112 TextBox
SubSubControl(4) OrderID_Label controlType 112 Label
SubSubControl(5) ItemId controlType 112 TextBox
SubSubControl(6) ItemId_Label controlType 112 Label
SubSubControl(7) Qty controlType 112 TextBox
SubSubControl(8) Qty_Label controlType 112 Label
SubSubControl(9) Price controlType 112 TextBox
SubSubControl(10) Price_Label controlType 112 Label
SubSubControl(11) SubTotal controlType 112 TextBox
SubSubControl(12) SubTotal_Label controlType 112 Label
SubSubControl(13) Item controlType 112 ComboBox
SubSubControl(14) Item_Label controlType 112 Label
SubSubControl(15) OrderDetailID controlType 112 TextBox
SubSubControl(16) Label17 controlType 112 Label
SubSubControl(17) OrderSubTotal controlType 112 TextBox
SubControl(8) OrderTotal controlType 109 TextBox
SubControl(9) Label11 controlType 100 Label
MainControl(20) FormTestAudit txtNameAtTop 109 TextBox
I will continue to work with the code you provided to see if I can use it in the audit trail material to get the proper form and controls and get passed the 2474 error. It's a learning exercise in an area that I haven't dealt with in depth.