Unanswered: Moving thru Subform
I have a bound subform, set to continuous forms. It may display anywhere
between 1 and 4 lines. I need a way, in my code, to move from record to record in that form.
This is a production planning form that has a massive amount of code behind it.
For example, suppose my code decides that Plant C the best fit for
production in Feb, and Plant C is the 3rd record on the subform. I know how to set the focus to the Feb field, but how do I move it to the third record?
The reason I don't want to update the base data using recordsetclone is because I have a lot of other code that fires off of the update field. I just want to automate the task of manual entry whenever possible.
Inspiration Through Fermentation