continuous form focus fumble

[thewiseguy]

hi there,

is there a way of allowing the user to press the tabkey at the end of a row on a contiuous form and shift the focus to the beginning of the row on the same form? i was hoping to use SetFocus in vba but i had no idea what expr. to write to identify the next row...

ta very much.

 

[Rich]

Set the Allow Additions property for the form to no

 

[thewiseguy]

sorry - i wasn't very clear the first time...

i'd like to use an IF clause to check if data has been entered into the current continuous form row (say check IsNull(firsttxtbox)). if it's null, i've got a setfocus command to take the user to another subform. but, if he has entered data in, i'd like it so that he can press the tabkey at the endtxtbox of the row and shift focus to the firsttxtbox of the new row below.

does that makes sense - i hope so.

 

[thewiseguy]

anyone got any clues???
mars-bar for the winner!

 

[thewiseguy]

d'oh - just figured it out using:

DoCmd.GoToRecord , , acNext
Me.firsttxtbox.SetFocus

sorry - still learning!