[AccessD] Error 2455

Rocky Smolin rockysmolin2 at gmail.com
Sat Sep 25 15:31:27 CDT 2021

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.



More information about the AccessD mailing list