Lock specific records at runtime in a form

[WCStarks]

By the way. Under the Events, in the embedded sub-form, I have a multi-select combobox for the Roles, because I often need to include more than one item. But the Access multi-select combo is a real pain to use. Has anyone come up with a better solution?

[June7]

AFAIK, a multi-select combobox is only possible when bound to a multi-value field. So if you don't like it, then don't use a multi-value field, create a related table in which each value will be selected in a separate record row. You need to understand this is what Access is really doing with a multi-value field, only the related table is hidden.

I have NEVER utilized multi-value field.

[orange]

You have mentioned Option Specific and Option Distinct, but the command is

Option Explicit
Good luck

[ssanfu]

<snip> I have a multi-select combobox for the Roles, because I often need to include more than one item. But the Access multi-select combo is a real pain to use. <snip>

As June said, that sounds like a multi-value field. Most experienced Access developers do not use multi-value fields, Look up fields in tables nor calculated fields in tables.

Microsoft did not fully implement the "multi-value field"; it is easy to enter data, but a real PITA to extract data.
Behind the scenes, a multi-value field is a many-to-many relationship, so you might as well set up a normalized design that is functional and easy to use and forget about multi-value fields.

[WCStarks]

Sorry for the confusion. I would have meant Explicit, which setting I enabled.

[WCStarks]

Thanks for your help