Hi all
I am converting data from one (badly designed) db to a new structure.
I have two forms that SHOULD represent the same data (but in a different format/structure)....however, I have either created new records somewhere or I am missing some records from my source for some reason
I appreciate that I SHOULD be able to find the 'missing link' by using a subform an connect data on a key.....however, that is not quite the solution that works for me in this instance.
Rather, I want to open both forms and then in form A, navigate through each record one by one. In the 'on current' event, I am trying to move to the NEXT record on form B
I have tried both of the following, but neither works.
Are you able to assist please ?
I am converting data from one (badly designed) db to a new structure.
I have two forms that SHOULD represent the same data (but in a different format/structure)....however, I have either created new records somewhere or I am missing some records from my source for some reason
I appreciate that I SHOULD be able to find the 'missing link' by using a subform an connect data on a key.....however, that is not quite the solution that works for me in this instance.
Rather, I want to open both forms and then in form A, navigate through each record one by one. In the 'on current' event, I am trying to move to the NEXT record on form B
I have tried both of the following, but neither works.
Code:
Dim Fm As Form
Set Fm = Forms!B
With Fm
.MoveNext
End With
Forms("B").MoveNext
Are you able to assist please ?