Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Save multi-select listbox values to a table

Status
Not open for further replies.

phbarbara

Technical User
May 16, 2002
10
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top