Using a listbox in a form to select multiple items for a record

[June7]

No, binding listbox to field will not work. Purpose of this listbox is to aid user in creating multiple records, not to display value from a record. In fact, if the form is bound to the destination Fulfillment table, will not work properly - as you discovered you get an unnecessary record in table if other controls are bound to fields.



As already noted, further data normalization might be better than this VBA approach.

[warren0127]

June, thanks for the feedback. I originally had the form setup to where the user can choose 1 product for each Fulfillment - which worked out fine. But then, the new requirement came out that the user should be able to select multiple products for each fulfillment in the form itself without having to do one at a time - this is where it became a challenge in which I do not know another way to normalize the data without appending with the SQL INSERT. If there is another way of doing this without VBA, I would certainly be interested.

Thank you,
- Warren

[June7]

Only way without VBA would be additional normalization - a table for the repetitive fulfillment info and then a related table for the product selections. Alternative code with the current Fulfillment table would be to carry forward the repetitive info into new record by programmatically setting the DefaultValue property of each control. https://www.accessforums.net/showthread.php?t=38447 In either case select one product from combobox per record on a bound form.