Enter data into a continuous subform through a button

[epardo87]

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

[June7]

Form does not need DataEntry property set to Yes in order to enter new record. If the new record row is available, just go to that row.

So with each button click you need to move to new row and populate product field. With code behind main form in button click event:

Me.subformcontainername.SetFocus
DoCmd.GoToRecord , , acNewRec
Me.subformcontainername.Form.comboboxname = appropriate product ID here.

[epardo87]

Thank you!!
This worked great!