Hi,

I am creating created a user form with a Combo Box where the user selects his name. From that I want a list of cases ( with unique casenumbers) he has to fill in. After the form is complete it needs to be added to the correct row.

I was thinking to search for cases where the username matches, and where a particular field is empty and copy all casenumbers to a range that can be used as input for a second combobox. The user can then select his cases, fill them in and the data added to the original row.

I have tried to piece this together by searching. But I am completely stuck. I hope anyone can help me.