[AccessD] Access lockup when using record selector search

[Jim Dettman]

LOL.

 With four kids, I can empathize with that!

Jim.

-----Original Message-----
From: AccessD On Behalf Of Rocky Smolin
Sent: Friday, March 26, 2021 4:05 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access lockup when using record selector search

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. :-)

r


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=s
haring
>
> 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