MS Access unwanted GUI effect.

MS Access moves screen view after executing event procedure. Please help to avoid this. How can I prevent from happening of what you can see on the attached image.I want the user to see checkbox values changed, no any other movements.
LVL 1
midfdeAsked:
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.

Russell FoxDatabase DeveloperCommented:
Try turning off the screen refresh with the application echo:
...Dim ap As Long
   Application.Echo False 
   ...
   Application.Echo True 
End Sub

Open in new window

0
midfdeAuthor Commented:
Sorry, the answer is wrong. Echo method is for something different. It does not and should not do what I want.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
How about this:

Dim vBm as Variant
vBm = Me.RecordsetClone.Bookmark.

'your execute NonQuery line of code here

Me.BookMark = vBm

However, question:
is the ExecuteNonQuery function requerying the Form ?
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

IrogSintaCommented:
Replace the line
Me.SelectedMet.Form.Recordset.AbsolutePosition=ap
with
Me.SelectedMet.Form.Refresh

Ron
0
Dale FyeCommented:
If I understand correctly, after the requery, you want the selected row to show up in the same position (vertically) within the continuous form as before you clicked the button.

Steve Lebans, one of the true geniuses in the Access community, has stopped updating his web-site, but has a database with some samples of how to do this on his web-site.

At the very bottom of that page, he says:
"OK, for most situations, one of the above 3 methods will work fine. Still,  you'll notice that the  row we've selected appears as the top row displayed in the Form. Again this can be disconcerting to the user if the record they were working on prior to the Requery was at say the bottom of the screen. In order to restore the  displayed order of the rows after a Requery requires jumping through a lot of hoops. I don't personally feel it is worth it but that's up to you. There is a sample database in this archive detailing what hoops to jump through. Have fun!"
0
midfdeAuthor Commented:
is the ExecuteNonQuery function requerying the Form ?
Not any more...
".Requery" --> ".Repaint
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.