Requery Subform doesn't work

[cokiere]

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

[ranman256]

If you have the subForm,why run a query?
just entire the data into the subForm.

but the requery does work.

[cokiere]

Hi!
Because it's a touchscreen PC. I wanna make a cashpoint.
It's not so real. Just learning
Thank You
See you

[cokiere]

...I mean... append query simulates the keyboard or precisely the button simulates the keyboard

[davegri]

I think you misunderstood ranman's suggestion. Use the touch event to run code to enter the data into fields in the subform, instead of an update query on the subform table.

[cokiere]

I think you misunderstood ranman's suggestion. Use the touch event to run code to enter the data into fields in the subform, instead of an update query on the subform table.

HI Folks
I try to explain better:
I have a form with source a query: ID (PK autonumber), Date, Time, Name, surname.
As subform I have: ID simple number, date, time, product, price,.
Linkmaster ID
Linkchilg ID
My goal is to get a calculation in subform and to get when i make the calculation in main form at the same time.
For having very easy this operation I make a button with append query. This query goes directly to the subform.
Probably do I have to swich the forms?
I made a form without the main form. But in my opinion is not the same.
I could make a second form like without button like edit session but for me it's not the same. Forgive me
Thank you so much for your time
see you

[cokiere]

hi
Please: I'd like show you a simple file. I can't understand. Probably It is a tiny thing for you but for me is a huge...
The Problem is: I can write in the subform with keyboard but I can't do the same with the append query.
I hope this attach will be more clear than me
Thank you

fromcokiere (1).zip

[davegri]

coke-davetri-v01.zip
Check Bread. It was not adding the foreign key to the subform recordsource.

[cokiere]

coke-davetri-v01.zip
Check Bread. It was not adding the foreign key to the subform recordsource.

Hello my Leader
while hitting my head I Say You Thank you
I feel a bit embarrassed
Thanks again