[AccessD] Access lockup when using record selector search

[Ryan W]

Yes the me.child1.form.requery absolutely does fix it as I discovered earlier

It is odd if it’s a side effect that it’s displaying the records in the sub form but built in controls are “broken” in a way that crashes access. 

Sent from my iPhone

> On Mar 26, 2021, at 5:41 PM, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
> 
> You are correct that it does cause records in the sub-form to be displayed, but that is just an 
> undocumented  side effect  of what Refresh is doing to the controls on the parent form. As 
> you have discovered, it does not fully configure the sub-form and its controls.
> 
> There is a lot of confusion between Refresh and Requery.
> 
> Replace Me.Refresh with Me.Child1.Form.Requery  and everything should work as intended.
> 
> 
>> On 26 Mar 2021 at 17:12, Ryan W wrote:
>> 
>> The me.refresh has made no difference in the lockup situation that
>> I´ve found.  Without it there, if I recall the data doesn´t appear
>> in the sub forms unless I´m calling requery on the sub form forms
>> themselves. 
>> 
>> I can test more Monday, but don´t believe it had any impact on the
>> lockup issue. 
>> 
>> Sent from my iPhone
>> 
>>> On Mar 26, 2021, at 4:45 PM, Stuart McLachlan
>>> <stuart at lexacorp.com.pg> wrote:
>>> 
>>> I think you will find that the root cause is your incorrect use
>>> of Me.Refresh on a form that doesn't have a recordsource. It's not
>>> doing to the sub-form what you think it is doing.
>>> 
>>> 
>>> 
>>>> On 26 Mar 2021 at 14:02, Ryan W wrote:
>>>> 
>>>> I think I found the root cause.  if the datasheet form properties
>>>> "allow deletions" and "allow additions" are set to no, the
>>>> datasheet form crashes if the search bar is used without a
>>>> me.form.refresh called first. If you turn them to YES for the
>>>> form1_subform form, the search crash doesn't happen. Here's a copy
>>>> of the testing db:
>>>> https://drive.google.com/file/d/1RcEQdm4n4-BvgDjGLmqn6FsAA9z7d3y1/v
>>>> iew ?usp=sharing
>>>> 
>>>> So the form will come up hit the "Get stuff" button, then go down
>>>> to the navigation pane in the subform and type in the search box,
>>>> it should crash. IF it crashes, re-open it and close the main form
>>>> (because it may crash with data in the temp table) and modify the
>>>> subform and set those two properties to YES and save and re-open
>>>> the main form (make sure the subform data is empty) and try
>>>> again... it should not crash.
>>>> 
>>>>> 
>>>> -- 
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>> https://databaseadvisors.com/mailman/listinfo/accessd
>>>> Website: http://www.databaseadvisors.com
>>>> 
>>> 
>>> 
>>> -- 
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> https://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> https://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com