Combo in subform display the previous value

[aym]

Hi everyone
I have a subform which have Combo(ProductID) and when click on a productID(which contains items: Biscuit, Sweet and Milo) it will display the price. The problem am encountering no is that if I select sweet for the 1st customer it will display the price and I will enter the quantity to get the Amount. Once I select sweet for the 2nd customer it will display the data for the 1st customer.

Please what could be the problem. And please am an Ms access learner not expert . Thank you for your usual assistance

 

[Jon]

Welcome to Access World! We're so happy to have you join us as a member of our community. As the most active Microsoft Access discussion forum on the internet, with posts dating back more than 20 years, we have a wealth of knowledge and experience to share with you.

We're a friendly and helpful community, so don't hesitate to ask any questions you have or share your own experiences with Access. We're here to support you and help you get the most out of this powerful database program.

To get started, we recommend reading the post linked below. It contains important information for all new users of the forum:

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We hope you have a great time participating in the discussion and learning from other Access enthusiasts. We look forward to having you around!

 

[arnelgp]

the subform's table should also the Sales/Invoice ID, so that you can Link it to the main form (Link Master Fields/Link Child Fields).

 

[aym]

the subform's table should also the Sales/Invoice ID, so that you can Link it to the main form (Link Master Fields/Link Child Fields).

Please how do I do the linking sir? Am not an expert. Thanks

 

[Gasman]

Crossposted https://www.access-programmers.co.uk/forums/threads/duplicating-values.334886/