[AccessD] Access lockup when using record selector search

Stuart McLachlan stuart at lexacorp.com.pg
Fri Mar 26 16:45:35 CDT 2021

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/view
> ?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

More information about the AccessD mailing list