K
kAREN
I am trying to automatically populate a subform based upon
a record being saved in the Main form. I currently have
the "After Insert" property on the Main form running a Set
Value macro to populate a field in the subform.
I have a parent/child relationship established on a field
called [Serial#]. The [serial #] field is populated when
the user enters data into another field on the subform. I
want to automatically update a field in the subform. The
field I want to update on the subform is [container #].
The container number should be the [Serial]&"-00/00".
when the set value action runs on the After Insert
property on the Main form, I get an automation error
message.
How can I automatically add a record to the subform?
a record being saved in the Main form. I currently have
the "After Insert" property on the Main form running a Set
Value macro to populate a field in the subform.
I have a parent/child relationship established on a field
called [Serial#]. The [serial #] field is populated when
the user enters data into another field on the subform. I
want to automatically update a field in the subform. The
field I want to update on the subform is [container #].
The container number should be the [Serial]&"-00/00".
when the set value action runs on the After Insert
property on the Main form, I get an automation error
message.
How can I automatically add a record to the subform?