[AccessD] Error 2455

[John Colby]

Bailiff, whack his pee pee!😁

I'm thinking you're old enough to remember...


On Sat, Sep 25, 2021 at 4:31 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> 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
>


-- 
John W. Colby
Colby Consulting