I have a problem with a dynamic table that I created in Designer 7.0.
Since there is no table in the 7.0 library (at least that I'm aware of), I created a sub form for the row. I use the instance manager to add rows when the user needs them. I wrote code that asks the user if they want to add a new row when they exit the last cell of the last row. If they answer "yes", a new row is added - if no, the cursor moves to the next field.
My problem is that when the new row is added, the cursor moves not to the first cell of the new row, but to the field following the new row. I'm guessing that this has something to do with the fact that my code is executed on exit, but I don't see any other way to run the script and have the new row added on exit.
Has anyone seen this problem before? Do you know a way to fix it?