Hello Everybody,

I want to use a static product listing form to select multiple items and then have these items copied(append) to my current order form. I 'm using a checkbox to select the items and when the form closes I reset the check boxes to false status.

Any ideas?

Your static product listing table should have a Yes/No field, I'll call it Buy. Bind this field to your checkbox on your selection form. When the selection form is closed, run an append query that will add all selected records to the table that keeps track of the orders, remembering to set the OrderID=to the current orderID on the form. Then run an update query to clear the selected items from the product listing.

~Charity