I have a combo box on a subform. When I enter a value in the combo that is not part of the list I want to launch another form where the user enters the new product. I would like to capture the value entered and pass it to the next screen so the user doesn't need to enter it twice.
Since the value I want is defined as the second column of the combo box which has 4, I came up with the following code and placed it in the onenter event for the field on the entry form:
Me.VendorProductNo=Forms![Purchase Orders]![Purchase Orders Subform].Form![ProductID].Column(1)
I get the error that I cannot assign a value to the item.
My question is how do I reference the combo box on the subform and assign it to the field on the entry form?
Since the value I want is defined as the second column of the combo box which has 4, I came up with the following code and placed it in the onenter event for the field on the entry form:
Me.VendorProductNo=Forms![Purchase Orders]![Purchase Orders Subform].Form![ProductID].Column(1)
I get the error that I cannot assign a value to the item.
My question is how do I reference the combo box on the subform and assign it to the field on the entry form?