Is it possible to update or copy the value of a field from one of it's subforms to a related field on the Form itself? The PurchaseID field in a Purchase subform is an AutoNumber and is the primary key. Once the AutoNumber in the subform is assigned, I want that value to go into the License Form's PurchaseID field. These 2 fields are linked in 2 separate tables.
When I've tried to do this with a macro or expression builder I get an error, "The object doesn't contain the Automation object 'Purchase.PurchaseID'." Am I trying to do something that can't be done?
When I've tried to do this with a macro or expression builder I get an error, "The object doesn't contain the Automation object 'Purchase.PurchaseID'." Am I trying to do something that can't be done?