[AccessD] Access lockup when using record selector search

Rocky Smolin rockysmolin2 at gmail.com
Fri Mar 26 15:05:24 CDT 2021

I find that often programming in Access is kind of like raising children.
You try one thing after another until you get the behavior you want.  And
then you don't know why your solution worked. :-)


On Fri, Mar 26, 2021 at 12: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.
> >
> --
> 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