Hi all, I have a form with multiple tiers that is updating columns in a table. I want the user to enter the data into some of the fields that are visible on the form. I would like the form to update the rest of the columns without the user being involved at all. I don't even want the user to see the other fields/columns that are being updated.
Long ago before we had EEPS, I created form variables to do the job of updating columns that were not on the form. It worked fine, but now, if I have lots of data, that seems to slow the form down. What is the best way to have my form update the hidden columns without having a visible field on the form for only the current row? I can make the field have a height and width of 0 and 0 and remove it from the tab sequence and use the property command to do the update. I think there is a property that I can use in the before start EEP to hide the fields I want hidden and use the property command to do the update. I can create form variables and live with the speed. I can create an app that runs through the data after the form is closed to update the fields. What is the best way to update just the current row/tier as the user enters data? Mike
