Multi select field locks out users

[krazieddi]

I have a form that uses a multi select combo boxes. When more than one person is in the database, if a user is updating any of the multi select combo boxes, it locks out other users from making changes to those fields on different records.

Can anyone explain why this is happneing? Can anyone offer a solution so that every user in the database can make changes to those multi select fields on their own specific records?

Thanks all!


-ed

 

[jdraw]

Google splitting an msAccess database.