Associate
- Joined
- 27 Jan 2005
- Posts
- 1,397
- Location
- S. Yorks
Having a bit of an issue with a combo box in Access 2003.
I have a form, bound to a table, the form has numerous controls one of them is a combo box. If I select the combo box, lets assume it has values A, B, C and C is currently the value for the combo box, If from the list of values I select C again the Afterupdate and change events are firing.
What is the best way to stop these events from firing?
I could set a variable for the form to hold the value and compare the new value with this one, but this seems a rubbish way round the problem, why does access not recognise that the same value has been selected?
regards,
Matt
I have a form, bound to a table, the form has numerous controls one of them is a combo box. If I select the combo box, lets assume it has values A, B, C and C is currently the value for the combo box, If from the list of values I select C again the Afterupdate and change events are firing.
What is the best way to stop these events from firing?
I could set a variable for the form to hold the value and compare the new value with this one, but this seems a rubbish way round the problem, why does access not recognise that the same value has been selected?
regards,
Matt