Don't use [Enter] key to move to next record

[lissa5402]

How do I stop my form from moving to the next record after hitting the ENTER key? My tabs are working just how I want them to but I do not want the form to scroll after I hit ENTER.

 

[Axworthy]

Set the Cycle property of the form to Current Record.

 

[lissa5402]

I tried that but it didn't work.

 

[missinglinq]

If the Cycle property of the form is set to Current Record and Tabbing is working correctly, <Enter> should behave in the same manner, barring the presence of custom code telling Access to go to the next record if <Enter> is pressed whil ein the last control.

Only other explanation I could think of would be corruption. Corruption takes on more forms than Tony Randall in "The 7 Faces of Dr. Lao!"

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[maccess]

Tools > Options > Keyboard
Set the option in 'Move After Enter' to 'Don't move'

Max