Insert Records by checkbox

[Soulfly]

Hi all,
I have an table with products, these products will be shown in an form. Now I want to place an checkbox for eacht product to select, at the end I want to place an button, when the user presses the button then all the product which are selected should be inserted into the table of orderinformation.

Does anyone have any tips to accomplish this?

Thanks in advance

Peter

 

[WayneRyan]

Peter,

On the Command Button:

DoCmd.RunSQL "Insert Into orderinformation (ProductID, Field1, Field2) " & _
             "Select ProductID, ProductField1, ProductField2 " & _
             "From   Products " & _
             "Where  YourCheckBoxField"

hth,
Wayne