Move to next row on Enter 1

[pgoulet]

I have a datasheet (sub form) with 6 columns, the left most column is already populated. The clerks want/need to be able to move to the next row upon pressing enter, rather than moving to the adjacent column.

How would I set this up in VBA.

Thank you.

 

[VBslammer]

Menu:

[tt]Tools --> Options --> Keyboard Tab [/tt]

Check the [tt]Next Record[/tt] radio button in the [tt]Move After Enter[/tt] frame.

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[pgoulet]

Thanks for the response. I already have that option set to work that way.

I wanted to be able to export the program and not have to worry about the condition of that option.

Any VBA idea?

Thanks

 

[RoyVidar]

The routine here thread68-986282, moves down columns when the tab key is used, could be a starting point?

Else you could issue a

[tt]application.setoption "Move After Enter", 2[/tt]

to alter the setting programaticly.

Roy-Vidar

 

[pgoulet]

Roy,

Thanks for the tip on that thread. That certainly looks promissing.

I will give it a shot and let you know. Thanks again.