Continuous form returning to top of data list

[andy49]

Hi all



I'm inputting test results in a continuous form.

Just one piece of data per student

The query which the form is based on is two joined tables so when I enter a score then another field next to it (grade) is filled in automatically

This all works fine except the focus then "returns" to the top piece of data.

Any ideas? I should add that the tab button moves the cursor to the next line which is what I need.

[June7]

Focus then "returns" to the top piece of data after each input and pressing Enter key?

[andy49]

Sorry June. Mad moment. After entering the value 24, I want to move to the next row. But it returns to the top (highlighted area).

Hope this makes a bit more sense.

[Missinglinq]

Sounds like the Form is being Requeried; I'd search your code for the line Me.Requery...maybe in the Form_Current event.

Linq ;0)>

[June7]

Right, pressing Enter key.

But tabbing moves to next line and wouldn't that also trigger the OnCurrent event?

It does seem like a Requery is taking place but where? If you have VBA code, do a search on the VBA code to find uses of Requery or even Refresh. If you are using macros, I don't know way to search them without a third party add-in like Rick Fishers Find and Replace.

[andy49]

Thx. I'll search my vba code for requery.

[andy49]

Good call!! Requery hidden away in an updater function which I'd borrowed. Thx.

[aytee111]

(Is your topic sorted? Please mark your thread as solved)

lol