Hi there,
Its been a while since I had to use access and I've forgotten about everything. So please consider me as a newbie.
So I have a form "POS" which has fields from "Sales" table and I have a continuous sub-form that shows the products of the Sales orders "SaleDetailSF". It works fine showing me existing records. What I need now is to create a new record, I have set the form to data entry "Yes". it also works fine if I just wanted to add the products directly clicking on the combobox field within the subform.
The thing is that I have some buttons on the parent form, each button represents a product (users will be using a touchscreen), so what I would like is that each click on the button fills up the "Product" combobox within the subform (both forms are already linked by SO number) and every other button click should fill a new record in the subform. I've been looking for ways to do it but examples in tutorial are not very helpful with this specific purpose.
I'll appreciate any help I can get on this