I think I may have resolved this. Well it seems to be working now anyway.
I believe part of the problem was that my relationship was getting invalidated and the second part of the problem was in the point at which filter was looking at the DisplayValue.
Regards
Geoff
>>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
May all your weeds be wildflowers