Multi-Select dropdown problem

[wrkadri]

Hi,



I have a database that keeps track of non-profit items distributions.
Usually distributions are done by one ore more field officers.
My database is split because I have two data entry officers working on it.
I have created a combo box that allows them to choose one or more field officers from an already existing table.
When they want to enter the data, they cannot do it in the same time because one of them is locking the record.

The error that they receive is: Could not update; currently locked by user 'Username' on machine 'Machine name'

Any solution?

Thank you in advance

[ranman256]

Don't Edit the record directly.
have a user click edit button, this copies the record to local table,
changes are made, click SAVE...
this updates all fields to the REAL record on server...thus, no one is EVER in the record.

[June7]

Why would users be editing same record at same time? Are they editing the same fields? They will overwrite each other. Whose data is correct?

[ssanfu]

Maybe the Default record locking is set to "All Records" instead of "no Locks"??

[wrkadri]

Why would users be editing same record at same time? Are they editing the same fields? They will overwrite each other. Whose data is correct?

They are not editing the same record. They are using linked table.
The case is that I am tracking the distributions.. The distributions table is linked to the field officers who made the distribution.. Whenever the data entry officers want to select who did the distribution, they get this error message.

Maybe the Default record locking is set to "All Records" instead of "no Locks"??

The default record locking is set to "No locks"

[June7]

Makes no sense to me that selecting item from combobox would lock some record. I suspect the form's RecordSource is not properly structured and/or combobox is bound to wrong field. Normally, a form can do data entry/edit for only one table. If you have multiple tables in the form's RecordSource, that could be an issue.

I have a split, multi-user database and NEVER seen this issue with a combo or list box.

If you want to provide db for analysis, follow instructions at bottom of my post.

[wrkadri]

Makes no sense to me that selecting item from combobox would lock some record. I suspect the form's RecordSource is not properly structured and/or combobox is bound to wrong field. Normally, a form can do data entry/edit for only one table. If you have multiple tables in the form's RecordSource, that could be an issue.

I have a split, multi-user database and NEVER seen this issue with a combo or list box.

If you want to provide db for analysis, follow instructions at bottom of my post.

Maybe I didn't explain it well.. Maybe the structure of my database is not correct.. I will try to be more clear and provide screenshots as soon as I reach the office. Thank you all for your support.

[wrkadri]

To be more clear with the problem I am facing, I am posting screenshots of the whole process:


This is the form in design view..


I need to select the field officer who did the distribution..


If someone else is also adding another distribution, I get this error !!!


Knowing that this is my row source..

I am not sure if the problem is in the dropdown list itself or in the form frmDistributionsFU

[June7]

You are saving name instead of ID? Names are poor unique identifiers. However, if you are positive there will never be more than one officer for same name, guess this will do.

I NEVER use multi-value field.

Still don't understand cause of record lock.

[wrkadri]

You are saving name instead of ID? Names are poor unique identifiers. However, if you are positive there will never be more than one officer for same name, guess this will do.

I NEVER use multi-value field.

Still don't understand cause of record lock.

I will remove the multi-value field.. It is giving me a headache for a while! LOL

Thank you for your support

[June7]

So what are you going to do if multi-value field is removed - a related table?

How did you resolve issue of record locking?

[wrkadri]

So what are you going to do if multi-value field is removed - a related table?

How did you resolve issue of record locking?

I created a related table that will hold the names of the officers responsible for each distribution.
It is working fine now.

Thanks