CODEWITHSUNDEEP
vbams-access
Joe
Joe

Reputation: 626

How to prevent MS Access report in subform scrolling down each time I use subform.Requery

I have a report in a subform called ViewCurvePrices. At the top of the parent form, a button contains the code:

ViewCurvePrices.Requery

It's pretty simple stuff and refreshes the values as I expect. Unfortunately though, the report also scrolls down about half a line after it runs, which seems like buggy behavior.

Have any of you come across this before, and is there a way to prevent this from happening? This doesn't happen when the requeried subform contains a regular form/datasheet - just when its a report.

I'm using MS-Access 2016.

Upvotes: 1

Views: 403

Answers (1)

Doug Coats
Doug Coats

Reputation: 7127

As Suggested by OP:

I think maybe Tab order has something to do with it, however you have sense discovered that TAB STOP was the culprit.

Upvotes: 2

Related Questions