Apologies if this already was posted. I have a form that inputs data about a project. There are a total of 3 list boxes that are on this form. When you press the save project button, a go-between table saves a record of the projectID and the dependencyID. These are multiselect boxes so it is possible to have multiple dependencies on the same project
Code:
project1, dependency1
project1, dependency2
What I would like to do is on form load the list box is highlighted with this information. I have about 50 some odd projects and everytime the form loads the data is cleared. I have already created a way to delete all records if the information changes, but I would like to be able to see what I have already done. I just need to get the listbox.itemsselected to talk to the data in the table.
Does this make sense? Any thoughts?
Thanks in advance!