MS Access - Update field in subform from main form – Error can’t find field

sambob_628 0
Viewed 37

I’m trying to create a bill of materials (BOM) table, the BOM links to the part number by the part number, The main form is named ‘New Part’ and the part number to assign the child material is held on the main form in a text box called ‘SCS Part Number’

The child materials are assigned in a subform named ‘Qry_BOM_RequirmentsV1 subform’ each new record is assigned the part number. This is achieved by using the after-update event property. When the material is selected from a combo box the part number from the main form is assigned to the ‘PrtNmber_LinkField’ enter image description here

Private Sub RequiredMaterialPrtNum_AfterUpdate()
   [PrtNmber_LinkField] = Me.[SCS_Part_Number]
End Sub

Its assigning the part number into the correct field but returning an error enter image description here

Any ideas what’s causing it?

ms-access vba
0 Answers
Related