1. The sales unit price for any item in the business that has a sales unit price, can be found on the salesprice list, and the app returns that as is expected on the Sales Invoice.
2. Many income items does not have a sales unitprice, therfore it has to be captured manually.
3. There is a button on the form that wil open the form f02SalesInvSubSub, as can be seen on the image, all work well.
4. The wish is for VBA code through an event to open the form, "after update" on quantity. The button is unwanted.
5. In the left bottom corner it can be seen that txtQuantityB2 is returned from the subform, to the main form.
6. The VBA below is placed on the main form. I am missing what I do wrong, the VBA does not open the form.
Private Sub txtQuantityB2_AfterUpdate()
If Me.txtUnitPriceSaleD > 0 Then
DoCmd.OpenForm "f02SalesInvSubSub"
End If
End Sub