Dynamic Checkbox Creation + multiple insert query

Cruz

Registered User.
Local time
Today, 14:41
Joined
Jun 15, 2004
Messages
15
I have a table that holds a list of products and services offered. What I need is a form that will dynamically produce a list of checkboxes that will update another table with their values of being selected or not. Is this possible? The purpose of the database is to help speed up costing for clients. This started out as something small and has ballooned into something way out of proportion.
I also need a query to be built based on the tblProducts; for every new client input into the system, I would like to automatically insert a value for the product for the client. IE when i put their name in the system the table that holds the selected values of products will automatically make new rows for that client that match up with the product. Can this be done?
Thanks for you help!
 
I would look for another interface. Adding checkboxes to a form on the fly is only the tip of the iceburg. You would also need to generate VBA code to work with these checkboxes which will need to be unbound.

Take a look at the multi-select listbox example that I posted. It includes code that loops through the selected items and adds a row to a table for each selected item. The application is meeting attendance but the procedure is sufficiently close to what you want that you should be able to adapt it.
Multi-Select Listbox
 

Users who are viewing this thread

Back
Top Bottom