Article ID: 123653
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q123653
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you try to add a new record to a subform, you receive the following
error message:
In Microsoft Access 97:
An error occurred while referencing the object. You tried to run a
Visual Basic procedure that improperly references a property or
method of an object.
In Microsoft Access 7.0:
An error occurred while referencing the OLE Automation object. You
tried to run a Visual Basic procedure that improperly references a
property or method of an OLE Automation object.
In Microsoft Access 1.x or 2.0:
Can't set value.
CAUSE
This error can occur if the subform's LinkChildFields property contains the
name of a form property.
RESOLUTION
Change the name contained in the subform's LinkChildFields property and the
name of the associated field in the underlying table to something other
than the name of a form property.
REFERENCES
For more information about the LinkChildFields and LinkMasterFields
properties, search the Help Index for "LinkChildFields," or ask the
Microsoft Access 97 Office Assistant.
Additional query words: setvalue
Keywords: kberrmsg kbprb kbusage KB123653