Works Great but I have a problem
I have been using this solution for almost a year and it has worked nicely. I recently implemented this code in a new database. On my form (based on one query) I have about 42 controls. I have 13 tabs on this form. My problem is that the SQL insert statement only gets generated for 30 of the controls. 12 are ignored. The 12 that are ignored reside on 6 different tabs. I ran the documenter for this form so I could check the properties of the fields that work and the fields that do not work. I also compared the properties of the tabs that work and the ones that do not. I can't see any difference in the properties. I tried generating a new justified data entry form with all fields from the query and called the audittrail function from the before update event for the form. I still had a problem with these fields. Then I generated a new data entry form with only 2 fields. I placed the primary key and a new date field, "PAPRTrainingCompleted". PAPR was being overlooked on my production form. When I triggered the before update event to call the audittrail for this form, the SQL statement was generated successfully. Is my problem too many controls on one form?
