Access datasheet view - jumps back to first fow, when typing

[olseni]

Hi all

I have a problem using datasheet in a subform (Access 2007).

When the user is updating numbers or text in a column, and jumps to the next record using the 'Enter' button, sometimes, but not allways, and with no consistency, the cursor jumps back to the first row, which of course is very annoying for the user when entering many numbers in a row.

Any ideas of why Access seems to do this, and what I can do to prevent if from happening....?
Thanks
Best regards
Ingrid

[missinglinq]

Does your form have code behind it?

DoCmd.GoToRecord , , acFirst

will cause Access to return to to the first record.

Me.Requery

or some variation on this will cause the same thing to happen.

So the first thing I'd do is go to the code module behind your form and use
search to hunt for either acFirst or Requery and see if either of these are present.

Also, in Design View, goto Tools - Options - Keyboard and see what Enter Behavior is set to.

Linq ;0)>

[NeoPa]

As Linq has implied, this is not the sort of behaviour you'd expect to see normally in a data grid. Ergo, there is probably some code behind the scenes explicitly telling it to do this.

[olseni]

Hi again
There doesnt seem to be any code behind the forms, however the form is a subform linked to an other form, and I tried removing the link between the two and that seems to do the trick, it was probably re-linking the subform to the top form, and that was probably what caused the problems. Thanks for your input on this matter.... :-)

[NeoPa]

Good for you Ingrid :)

Glad you got it sorted.