Multiple Value Combobox

[whojstall11]

I have a Multiple Value Combobox that I have linked to one of my forms and I am trying to write some vba code that will allow on update, "if a certain item is clicked open up a different form". All i am having trouble with is referencing an item in the

If Me.Software.Column(1) = "Lawson Prod" Then combobox DoCmd.OpenForm "Lawson_Roles_Groups_frm", acNormal, , "EmployeeID = '" & Me.EmployeeID & "'"

Else
MsgBox ("It worked")
End If
End Sub

This code gave me no error but it wont read that "Lawson Prod" is selected. Can anybody help?
here are screenshots of my combobox and form.

[June7]

That's because you are using multi-value field. I NEVER use multi-value field because of the complications in referencing data.

[whojstall11]

So what is an alternative way store multiple values into a record.

[June7]

Multi-value field is a non-normalized data structure. Normalization would call for a dependent table to hold record for each selected item and use subform for data entry.