Preventing a combo box from changing current record?

[andrew.bistak]

hi all,
I have three values in a record labelled "Local, National & Rural", I want the user to be able to select one of these options, (e.g. Local) and then be able to right click and sort be selection.

However, when I lock the combo box, you can't select anything but if it is unlocked, it changes the current record to whatever the combo box has selected.

Is there a way around this?
regards,
Andrew

 

[RuralGuy]

Welcome to Access World Forums!

I'm going to guess that there is code in the AfterUpdate event that needs to be commented out for now.

 

[andrew.bistak]

Hi,
Thanks RuralGuy, I've found a workaround to the solution It was driving me crazy for 3 days and all of a sudden I had one of those "clear" moments.
cheers,
Andrew