Hi, Mr. Petti.
I can think of two reasons for this.
1.) You have installed Office XP SP-3, and your code is attempting an
operation that affects the current record, such as deleting the current
record from the main form, but there is at least one bound subform embedded
in the bound main form. This is a confirmed bug in SP-3.
2.) A form's record source has been changed, and at least one of the
controls on the form is being referred to in VBA code by its control source,
not the control's name, but that control source isn't one of the fields in
the form's new record source.
If your problem is caused by reason #1, then you have several choices. You
can get rid of Office XP SP-3 so that Office XP SP-2 is the highest service
pack installed, or upgrade to Office Access 2003, or wait for Office XP SP-4
to be published (no guarantees that SP-4 is going to be published, though).
Or you may be able to change the code to avoid the current problem, but
we'll need more information about the operation affecting the current record
and the code where this error is occurring before we can offer help. (Note:
I'm heading off away from my computer for a good part of the day, so if you
need immediate help, somebody else is going to have to help you. I'll be
back later tonight, and I'll check the newsgroup then.)
If your problem is caused by reason #2, then you need to investigate which
control is the offender and delete the control if it's no longer needed, or
reassign the control's control source to an actual field in the form's
current record source.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
