[AccessD] Access lockup when using record selector search

Ryan W wrwehler at gmail.com
Fri Mar 26 14:06:50 CDT 2021

Upon closer inspection it may simply be "Allow Additions" = no that causes
the crash.

On Fri, Mar 26, 2021 at 2:02 PM Ryan W <wrwehler at gmail.com> 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.

More information about the AccessD mailing list