[AccessD] Error 2455

[Paul Hartland]

Did you come across this site when searching for solutions....

https://stackoverflow.com/questions/10401501/microsoft-access-runtime-error-2455-when-trying-to-access-grandchildren-forms-fr

Paul

On Sun, 26 Sep 2021, 01:23 Rocky Smolin, <rockysmolin2 at gmail.com> wrote:

> Gustav:
>
> As I 'Next Record' through the recordset, it displays correctly Clients
> that have no Persons associated with it.  If I look at the Client ID where
> it blows up, 1) it blows up on difference Client records, and 2) when
> selected from the combo box, that Client displays correctly. And in these
> tests the Client has Person records to display in the sub-form.
>
> I changed the form format to include Navigation buttons and as fast as I
> can click on the next record button, it never errors out. However, when I
> stop clicking the button, a few more records are accessed so I suppose
> there are a few clicks in the buffer.
>
> Is it possible that my 'Next Record' routine is a problem?  It''s pretty
> simple code and I've been using it for years without a problem being
> reported by any user:
>
> On Error GoTo IsIt2105:
>
>    DoCmd.GoToRecord , , acNext
>    Exit Sub
>
> IsIt2105:
> If Err.Number = 2105 Then Exit Sub
>
> MsgBox "Error: " & Err.Number & " - " & Err.Description
>
>
> MsgBox "Error: " & Err.Number & " - " & Err.Description
>
>
> Thanks for your help.
>
> Rocky
>
> On Sat, Sep 25, 2021 at 3:07 PM Gustav Brock via AccessD <
> accessd at databaseadvisors.com> wrote:
>
> > Hi Rocky
> >
> > It sounds like one of the main records has no child records.
> >
> > /gustav
> >
> > -----Oprindelig meddelelse-----
> > Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På
> > vegne af Rocky Smolin
> > Sendt: 25. september 2021 22:31
> > Til: Access Developers discussion and problem solving <
> > accessd at databaseadvisors.com>; Off Topic <dba-ot at databaseadvisors.com>
> > Emne: [AccessD] Error 2455
> >
> > Dear List(s):
> >
> > I have a form that has a 'next record button' that moves the bound form
> to
> > the next record.  When it does that the Current event, which has a bunch
> of
> > code in it, runs.
> >
> > If the user toggles cycles the recordset with the Next Record button, it
> > eventually errors out with an error 2455: You entered an expression that
> > has an invalid reference to the property form/re;port.
> >
> > The line of code it errors is:
> >
> >  Me.sfrmClientPerson.Form.Section(acHeader).BackColor = 15263976
> >
> > It's part of the process of turning the form gray and disabling it if the
> > client is inactive.  This line of code refers to a subform.
> >
> > I tried putting in a delay of one or two seconds at the top of the
> current
> > event, on the theory that maybe the subform references in that line of
> code
> > is not finished loading yet.  DoEvents also was not effective.
> >
> > Any ideas on how to fix this? Other than telling the user not to toggle
> so
> > fast through the records and use the Find button instead.
> >
> > MTIA
> >
> > Rocky
> > --
> > 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
>