ComboBox not Updating Field

[The Professor]

Hi All,

I have a Combo Box control on a data entry Form which shows the data for three different Fields in the underlying Table in it's drop down list. It's bound to one of them and that is the data that is displayed in the text box, obviously.

However, when a new, blank record is created and initial data is entered into the Combo Box Control for that new record, all is fine. The Field in the underlying Table is updated with the initial data.
But, if I change my mind and go back to that field and alter/edit that data, the Combo Box will display the new amended data but the underlying field is not updated. So that if I navigate away from that record and then return to it, the Combo Box will display the old data and the amendment will have been ignored/discarded. In terms of Properties "Limit to List is NO" and "Allow Edits is Yes".

What seems to be happening is that the first entry into the Combo Box is the only one it will accept and any future or further edits or amendments are just ignored even though the Combo Box appears to be accepting - the underlying Field/Table is not been updated. Not sure what is going on here, but I'm probably just missing something obvious I expect, but I'd be grateful if anyone could point out to me what that might be.



Cheers,
Prof.

[June7]

Can you provide db for analysis? Follow instructions at bottom of my post.

[The Professor]

Hi June7,

Many thanks for the offer and much appreciated but, with the help of a friend, I have managed to get to the root of the problem - it boiled down to a dodgy piece of code which has now been rectified.

Prof.