How to prevent a Subform to create a new Datasheet (2of2)

[Raskahl]

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?

 

[theDBguy]

Hi. Welcome to AWF!

Sounds like you could try setting the Cycle property of the subform to Current Record.

 

[Raskahl]

Hey guys thanks a lot for your fast and exhaustive answers,
I would love to convert to a relational database but honestly I'm afraid I would screw up all the work I did till now (alot of hours) and also im not sure I would be able... (as said before, I'm not a programmer, just an amateur that needed a way to store data for a medical study and was already proud of what I had achieved although I now understand it's quite a mess hehe)
I did however change the ID to long integer in the 2 parent tables as you suggested and also changed the cycle property.
I will definitely try to use a relational database the next time I will do an access Form =)
Or otherwise would anyone of you do it to this database? Of course with reasonable monetary compensation
Best thanks to all of you!