Forum Discussion
Access 365 2302 16130.20218 Subform with sourceobject query has interesting glitch
I've got a form with a subform that has a stored query as a source object.
When I cursor over the data, I get what appears to be some of the query design elements:
Here is the "show" checkbox
Crosstab pulldown:
Total pulldown:
I thought maybe it was some form corruption so I tried making a new form with a subform referencing the same stored query and got the same result?
It also does this with stored queries that are NOT crosstabs (like the above example)
Here's a short video of the glitch in action:
I've tried setting the subform control to locked = yes/enabled = no to no avail.
Here's a link to a basic 1 table / 1 query /1 form mdb that reproduces the glitch:
Another note: using the runtime simulation flag from the command line, the subform now shows NO data but you can still click in / around to get the query designer elements.
Thank you for confirmation. I hadn't seen anyone else mention it. You can roll back to the Feb 14 version and it'll fix it in the interim.
- I can confirm that the bug has been replicated/acknowledged by the Access team.
There is also another new bug connected with the query designer window.
Hopefully a fix to each will be provided soon
- I did some rollbacks and found it only appears to be affected by the latest update: Feb 28 - Version 2302 (Build 16130.20218) - **affected** Feb 14 - Version 2301 (Build 16026.20200) - unaffected Jan 26 - Version 2301 (Build 16026.20146) - unaffected Jan 10 - Version 2212 (Build 15928.20216) - unaffected Jan 4 - Version 2212 (Build 15928.20198) - unaffected
- Thank you for this contribution! Saved the day.
