[AccessD] Error 2455

[Gustav Brock]

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