I need to save multiple values from a list box to a table. I found a partial answer in thread 702-591670. It makes sense to set-up a "detail table" that would capture the primary key from one table and save it with the value from the list box as Scriverb suggests. My problem starts with his statement "after all of the selections are made from the list box we can execute VBA code that will create X number of Dependencies records". I don't write code, I cut and paste and change object and field names! What would the code look like that would generate these new records? I have a table of Health Care Providers tblProviders with primary key ProvID and need to save the provider ID with their areas of expertise to tblProvExpertise from the data entry form frmEnterProvider!lstExpertise. Can anyone help? Thank you.