User station seems to be refreshing when it shouldn't

I have a sub form that contains a list.

The sub form has a button that when pressed,
               adds a new record to the list
               enters some data into one of the fields in the new record
               and then sets the focus on the first field needing entry in that new record.

Works fine ....  Except....

On one user's station, occassionally when he clicks to add a new line, it does everything it is supposed to do but then takes him to the first record in the list, instead of staying on the new record.

It appears that it is REFRESHING or REQUERYING the data and causing this.

possible clues....
It seems like it does this when he gets enough records to force the vertical scroll bar to appear

It also seems like his combo boxes are autocompleting incorrectly, for example....
if there are names like CARLSON, CARLTON, CARPENTER, if he is entering CARPENTER, by the time he gets to the letter "P", it has already entered in "CARLSON" and refreshed the control.

I am putting this together in 2007, he is using 2010... Problem?

Is there some simple setting in ACCESS (or OFFICE) that is refreshing things when it shouldn't.
Thanks in advance.
TechGuiseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Does this happen on ONE machine only, and not others? If so, then be sure that machine is fully up to date in regard to Office and Windows. Also try logging into that machine as a different user. If the behavior stops when logged in as a different user, then you may have a corrupt user profile.

Also - is the database split into a Backend (Tables only) and a Frontend (everything else)? And have you deployed a COPY of the FE to each user?
0
TechGuiseAuthor Commented:
So far, it's only on one machine.... But this user is sort of the BETA tester, so other than several machines I have in my office, it's not being tested much yet on others.  Will login to their network and try some others.

Yes database is split, yes each user has local copy of Front End.

Thanks
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Could also be timer code running on a form, but then that would affect all users, not just your Beta tester.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TechGuiseAuthor Commented:
No solution, but based on emails and "ABANDONED" tag after 5 days, I get the feeling EE wants things like this to go away rather than let experts have more time to solve.  Thanks for responses Scott.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
EE doesn't want you to close things out with no solution, but they do expect you to maintain activity. If you don't respond to Expert comments to let us know we're on the wrong track, we assume you've lost interest and stop our participation.

Also, it's sorta rare that Experts will review questions that are older, and are being handled by others. If you'd like try and attract more Expert attention, use the Request Attention button and ask the Moderators to send out alerts.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.