View Single Post
  #1 (permalink)  
Old October 9th, 2008, 10:48 PM
Posts: n/a
Default Populate a list box from comma separated values

I'm trying to populate a list box from a single field in a record and also update entries in the single field from the list box.

This is simular to Outlooks Contacts Category function where if you select a category or categories from the list box to add to a contact it save all the category name in a single field separated by a comma. But the list box shows each category name as a separate line item.

Adding a category appends the field by adding the category name with a comma.

Removing a category removes the category name from the single field.

I hope this makes sense. I thought by using Outlook as example would give everyone a working model of what I am trying to do.

I'm new to VBA and Access but I have come a long way in the last six months.

The reason I need this to work like above is because my application is managing Outlook contacts via Access and if I can get the category names in a single field in a record separated by a comma, then I'm golden.

Thanks in advance.

Reply With Quote