Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

User station seems to be refreshing when it shouldn't

Avatar of TechGuise
TechGuiseFlag for United States of America asked on
Microsoft OfficeMicrosoft AccessMicrosoft Applications
5 Comments1 Solution284 ViewsLast Modified:
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.