Tabbing through controls creates Record!

[SodaJim]

How can I stop a form from creating a new record when tabbing through the controls on the form...?
My end users are continuously creating a new record on tables that have one to one relationships. I want to stop them from doing this...
Any direction appreciated!

 

[Mile-O]

On the Form's properties there is one called Cycle which appears on the Other tab.

Change this from All Records to Current Record and all your problems will be solved.

 

[SodaJim]

Many Thanks!!!