Can anyone help me code this feature?
The objects design: Main form with a tab control and multiple tabs. On one tab is a sub form with continous forms type.
Functionality: The user can enter currency values in several fields on the tab specific sub form records. After each value is updated, recalculate an unbound control with an expression that totals all currency values for every record related to that main form record.
Problem: I have this working but unfortunately when I requery on after update the cursor moves to the first record. The user would like to update the total on the main form and then either:
1- goto a new record on the sf if the last field triggered the event
2- go back to the next field in the tab order based on the field and record that triggered the event.
I'm not that experienced with tab references nor with remembering the current record and control and then returning. Any advice and sample code is appreciated!
The objects design: Main form with a tab control and multiple tabs. On one tab is a sub form with continous forms type.
Functionality: The user can enter currency values in several fields on the tab specific sub form records. After each value is updated, recalculate an unbound control with an expression that totals all currency values for every record related to that main form record.
Problem: I have this working but unfortunately when I requery on after update the cursor moves to the first record. The user would like to update the total on the main form and then either:
1- goto a new record on the sf if the last field triggered the event
2- go back to the next field in the tab order based on the field and record that triggered the event.
I'm not that experienced with tab references nor with remembering the current record and control and then returning. Any advice and sample code is appreciated!