I have three integer fields, and a Total field. The three fields have Automatic Field Code that sums them and places the result in the Total field. It has been working, but now a problem is occurring when the file is first launched.
All four fields are displayed in a form, and a popup button calls a proc that looks up a value and places it into one of the integer fields. The proc then uses a runfieldcode statement to trigger the Field Code.
When the file is first opened, with the form in front, the popup works, the looked-up value appears in the first integer field, but the Auto Field Code refuses to run. The Total does not change, in my form, nor in the Data Sheet.
This continues for any record, until I click into any one of the three Text Editors associated with the integer fields. As soon as I do that, the Field Code runs immediately, and also thereafter when the popup triggers its procedure, and the Total is updated as expected.
And, I just discovered that running my Duplicate Record procedures, which clear some fields (but not the integer fields) causes the problem to reappear. The Auto Code does not run, even after changing records, until I click once in one of the integer field TEs. Then everything works fine, until I duplicate another record.