[AccessD] [EXTERNAL] Re: Access lockup when using record selector search

Shane Groff shaneg at microsoft.com
Fri Mar 26 23:36:38 CDT 2021

The reason setting AllowAdditions to true makes a difference is that when it is set to true, then when the subform is first opened it has a single 'record' (the blank new record)
If it is set to false, then since the subform has no other records, so no records are displayed (and there is nowhere valid to put the focus in the form).

Getting the form open with no place to put the focus is one of the necessary conditions to hit this bug.

I will open an issue to track this.  As always it is more likely we will fix a bug in Microsoft365, then it is that we will fix it in Access 2013 (or any of the perpetual license versions).

Thanks for providing a repro case Ryan.


-----Original Message-----
From: AccessD <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com> On Behalf Of Ryan W
Sent: Friday, March 26, 2021 3:51 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: [EXTERNAL] Re: [AccessD] Access lockup when using record selector search

This still doesn’t explain why .allowadditions = true or .allowdeletions = true seems to remedy the .refresh glitch without a requery...  very odd indeed.  

The underlying data isn’t changing on this form as the tables are local to the user and not linked to the back end.  

Since you’ve seen the mock code that’s basically happening on my real FE. Moving data from BE to local table for processing. 

Sent from my iPhone

> On Mar 26, 2021, at 5:45 PM, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
> Refresh method
> Use the Refresh method to immediately update the records in the 
> underlying record source for a specified form or datasheet to reflect 
> changes made to the data by you and other users in a multiuser 
> environment. The Refresh method shows only changes that have been made 
> to the current set of records; it doesn't reflect new records or deleted records in the record source.
> Requery method
> Use the Requery method to update the data underlying a form or control 
> to reflect records that are new to or have been deleted from the record source since it was last requeried.
> If you want to requery a control that isn't on the active object, you 
> must use this method, not the Requery action or its corresponding DoCmd.Requery method.
>> On 27 Mar 2021 at 8:40, Stuart McLachlan wrote:
>> There is a lot of confusion between Refresh and Requery.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdata
> baseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=04%7C01%7Csha
> neg%40microsoft.com%7C892a1d206ceb4d92b79008d8f0a9a336%7C72f988bf86f14
> 1af91ab2d7cd011db47%7C0%7C0%7C637523958678051883%7CUnknown%7CTWFpbGZsb
> 3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%
> 7C1000&sdata=y8RM97EVyey4LUv%2BOxgJMz3CFDCgxyaJgnNYQ9xaDhY%3D&
> reserved=0
> Website: 
> https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.d
> atabaseadvisors.com%2F&data=04%7C01%7Cshaneg%40microsoft.com%7C892
> a1d206ceb4d92b79008d8f0a9a336%7C72f988bf86f141af91ab2d7cd011db47%7C0%7
> C0%7C637523958678051883%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLC
> JQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ZMMMnrNf
> jyguXAgGMyDG3j68AE5zjo9ngOS4o7P6UUo%3D&reserved=0
AccessD mailing list
AccessD at databaseadvisors.com
Website: https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.databaseadvisors.com%2F&data=04%7C01%7Cshaneg%40microsoft.com%7C892a1d206ceb4d92b79008d8f0a9a336%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637523958678051883%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ZMMMnrNfjyguXAgGMyDG3j68AE5zjo9ngOS4o7P6UUo%3D&reserved=0

More information about the AccessD mailing list