Checkbox on subform

[SunTop]

Hello everyone,

I have a form that I use to create orders for customers. Inside that form I have a subfrom that I select products from to go with the order. The controls on the main form are attached to the orders table and the data the user inputs in the main form goes directly to the orders table. The subform has a combo box in it, that has the row source set to the products table and the control source is set for the order Details table, so that the user can select the products from a drop down list. What I am trying to do is make the subform shows all the products as a checkbox so that the user ticks the products that he wants to go with the order instead of having to select them from a combo box, but I am stuck and I don’t know how to do this, any hints ?

[ranman256]

This may not be the best method. The list could be 200 records long and cannot be connected to the subform,
and youd need another method to add the checked items to the subform when user is done. (vb code)

Alternatively, what about a listbox with all products?,
user dbl-clicks the item, it gets added to the Order subform. (append query)
a find button to filter the list, instead of scrolling 100s of recs.

On the Order Form, user clicks Add Products button that opens the pick list form,
user dbl-clicks item, it runs append query to add it to Order subform (using Order ID below Client Name)
when all items added, this form closes, and user can adjust the subform (qty , or remove record)
(see photo)

[June7]

Is this a multi-user split db? Your checkbox idea would require a yes/no field in Products table. Then an INSERT SELECT sql action could save checked products to OrderDetails table. However, simultaneous users will conflict in setting checkbox unless the table with checkbox field is in frontend.

Ranman suggestion is a common approach and has been discussed numerous times.