>>Putting the call to refresh in the interactive change event of the combo box does not do the right thing, as it then will
not update the underlying field, effectively preventing the user from changing the field.
>
>In teh Interactive change you have updated the control's value, but you haven't updated the control source yet. Thats just how the event order works. Well, when you Refresh() when teh control is pointing to new value, and teh control source is pointing towards the old one, the refresh updates the control with whatevers in the control source, and thats why the old value keeps reapperaring.
>
>Try putting the refresh() in either the Valid() or the LostFocus()
Thanks Mike, thats what I found out. <g> I had trouble trying to use interactive change in a textbox once, where the effect was to reverse what the user typed into the box. you typed 'BOS' and it showed up 'SOB' was really kinda cute!
Jim Newsom
IT Director, ICG Inc.