pbaldy - I stumbled across your "Use a Multi-Select Listbox to Add Records to a Table example". It is exactly what I wanted and I have incorporated it into my form. Thank you! However, in your example, after I click the submit button the controls do not refresh. The records are successfully inserted into the table but the form controls continue to display what I just typed/selected. I thought I could simply add the Me.Requery to the code but this does not resolve the problem. What do I need to do? http://www.baldyweb.com/MultiselectAppend.htm