Add multiple records on one from by selecting items on other form.

[jevans]

Hello Everyone,

I have an Order(main)form and Orderdetail(sub)form, which I use to generate invoices. The underlying tables have a one to many relationship. The OrderDetail form contains the individual line items of the order. I also have a Product Select form with checkboxes attached to each product record. What I'm trying to do is populated the OrderDetail form by checking off the checkboxes in the Product Select form and having the related data autofill the OrderDetail fields. Can somebody please help me?

I was able to accomplish the transfer of only one record, but not multiple records!

 

[neideb]

Re: Add multiple records on one form by selecting items on other form.

Hi all,
I have a similar problem. In subform i would like to have a list box and checkboxes so that i could select the products i want to be saved in detail table.
Although this thread is already 11 years old hope someone could help me in any way.
Ths a lot:banghead: