Hello
I'm working to a simple form with subform.
Master form:
ID Key autonumber
IDOP shorttext
date
time
note
Subform table
ID number
IDO Short text
date
time
product
price
note
linkmaster ID;IDOP
linkchild ID;IDOP
I wanna write on note fiel "product and price" through a button. This button open a query:
INSERT INTO subform ( product, price, )
SELECT pricelist.product, pricelist.price
FROM pricelist
WHERE (((pricelist.IDpr)=1));
It is very simple but the subform doesn't make requery.
I tried with set up "afterupdate":
Me.Subform.form.requery
and
Me.subform.requery
Please can you explain me where I mistake
Thank you everybody