Unanswered: Concurrent form usage problems with multiple users
My question pertains to usage of any particular form concurrently by 2 users. My company uses an Access database and in that there is a form to enter equipment based on a particular area and sub area. But the problem is lets say, I am entering equipment for area 31 sub area 10, and if another user opens up the same form and selects area 31 but sub area 20, that particular value for sub area changes on my form too and becomes "20" from the previous value of "10". I presume it has something to do with locking, but cant figure out how to get around this problem? Can anybody tell me what's going on and how to trouble shoot this prob?