Hello guys I'm new to the Forum and relatively unexperienced with Access,
I Need to create a large Form for medical data Insertion and since the number of values to insert was Huge i had to create two subforms.
To facilitate moving from subform to subform i added a lost Focus on the last entry of the subform to jump directly to the main form and then to the next subform.
Sadly when i press TAB from the last entry it does correctly jump to the next subform but it also creates an additional datasheet (2 of 2) in the subform,
how can I prevent that? It's annoying since all the entered values disappear and so confuse the People that are doing the data Entry and also is a potential for mistakes.
Thanks alot in advance
P.S. sometimes it seems to work flawlessly and sometimes it jumps to somewhere random, could it be because of different Access Versions?
I Need to create a large Form for medical data Insertion and since the number of values to insert was Huge i had to create two subforms.
To facilitate moving from subform to subform i added a lost Focus on the last entry of the subform to jump directly to the main form and then to the next subform.
Sadly when i press TAB from the last entry it does correctly jump to the next subform but it also creates an additional datasheet (2 of 2) in the subform,
how can I prevent that? It's annoying since all the entered values disappear and so confuse the People that are doing the data Entry and also is a potential for mistakes.
Thanks alot in advance
P.S. sometimes it seems to work flawlessly and sometimes it jumps to somewhere random, could it be because of different Access Versions?