Customer Pricing

I can make the customer price special as how RICHARTS CREATES customerpricingQ2
But I if the price goes up, so I have to change in the subform of the orderf.
Can I still use the same procedure in the afterafdate property

Me.newprice=me.productid.coloumn(3)

With productid in the customerpricingQ2

Usually the productid is from PRODUCT TABLE...

Can we use productid of CUSTOMERPRICINGQ2 in the procedure as above

Me.newprice=me.productid (from a query).colomn(3)

Thanks 🙏🙏

I can not get the new price if I use productid of CUSTOMERPRICINGQ2

I want to get the new price with changing the customer pricing that we have created

I want to change the NEW PRICE to THE PRICE OF CUSTOMERPRICEQ

if the price goes up I want to change to this price or there is a way using customerpriceQ to change the newprice (in my subform)

thanks alot

how to send my ms access,please

thank you

Is there a way to change the new price in the subform with a query 🙏🙏🏿🙏🏿