error selecting from combo box

[Fredrated]

I have a form with a combo box that allows a user to choose from a list of
agencies.

The combo box is not connected to anything, i.e., it is not bound to a
database field.
It simply displays an agency name (and the agency id is available
internally), the datasource is
SELECT Agencies.Name, Agencies.ID FROM Agencies ORDER BY Agencies.Name;

However, half the time a user selects an agency from the list, an error
message appears:

'The data has been changed
Another user edited this record and saved the changes before you attempted
to save your changes.
Re-edit the record.'

If the user then selects again, there is no error message.

Any idea why this error appears, and, better yet, how to make it go away?

Thanks, Fred

 

[Jeanette Cunningham]

Hi Fredrated,
sometimes when there is an error with such a simple thing as a combo, I just
delete it and create a new one. This often fixes the problem. Hope it fixes
yours.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Fredrated]

Looks like you were right, recreated the combo box and the problem went away.
I don't know why I didn't think of that, I have certainly had enough cases
where nothing worked until I rebuilt something from scratch.

Thanks for your help.

Fred