>I’ve got a form (part of a formset) in VFP5 under WinNT3.51. Things start out with the focus set to a textbox - based on the textbox input, I want several other controls on the form to have their values changed programmatically.
>
>The *problem* is that if I leave the textbox by clicking on another control, everything works fine, but if I leave by pressing TAB, not all other controls get updated.
>
>In particular, I’ve got a combobox with a SQL rowsourcetype that I’m trying to set the value of. There’s a line in the Valid code of the textbox that’s close enough to:
>thisform.cboMainLite.Value = cNewMLValue
>
>Again, this works FINE if I click to another control, but fails if I leave the textbox by tabbing (all other things being, as far as I can tell, equal). By failing I mean that the combobox displays nothing - although the debugger says that the Value *and* DisplayValue properties are what they should be. Forcing a form Refresh doesn’t seem to help.
>
>Any replies greatly appreciated!
Two ideas.
1. Try a thisform.cboMainLite.requery in the lost focus of the combobox
2. If based on a sql, do you need the combobox style or is list style for the combo box more correct. Tab works much better with the style set to list. If you need to add new items to the list then you'll need special code.