Tab Key causing Access to Crash after open a report (1 Viewer)

[jmark@stayintouch.us]

Very strange. i have an Access 2019 report that opens just fine and filters and prints fine and closes fine, but if I open it and then the very first action is to hit the Tab Key on my KB, it crashes Access. Using Windows 10 Pro with all updates and Access 2019 and the same issue occurs on all Computers, every time. If I set the Grouping BEFORE the sorting, then the crash no longer happens, but the report does not then sort properly. Does anyone have any suggestions. I have attached a much reduced version of the full DB, but left the single report that is causing this issue. There is a BE and FE, so if you want to check this out, you will have to reconnect them after downloading them on to your PC.

I would appreciate any help. I would be available by phone or screen-share session if that would make it easier.

Thanks!

 

[CarlettoFed]

The problem comes from the Cycle Property in the Other tab, you have to set it to Current Record. The filters would be better to make them in a data summary mask and then eventually print the result.

 

[arnelgp]

why you did it in the report anyway.
normally this is done through a Form.

 

[Gasman]

Crossposted https://www.utteraccess.com/topics/2062032/posts/2788077
and https://www.accessforums.net/showthread.php?t=84557

 

[jmark@stayintouch.us]

The problem comes from the Cycle Property in the Other tab, you have to set it to Current Record. The filters would be better to make them in a data summary mask and then eventually print the result.

Very nice! How did you figure that out? Or are you just extremely intelligent! Either way, I THANK YOU so much and Im very glad to learn it is something as simple as that! I have just advanced my knowledge thanks to you! Enjoy your day!