>Hi
>
>I have a little problem where I need to restrict the values that can appear in a combo. The calculation as to what may or may not appear in the combo box is complex so I use a series of select statements to rebuild an internal cursor. The cursor is ZAP'ed in the When method.
>
>No problem so far.
>
>The problem comes when I
This.requery()
in the When or GotFocus event. For some reason my combo.value gets changed.
>
>Can someone explain why and if there is any way to avoid this???
>
>Regards
>Geoff Scott
Geoff,
I think we might need some more detail on this. What are your values before and what do they change to. Are you seeing this as you step through the code or only what is displayed as you run the form? What are your steps to reproduce this?
Renoir