Combo Box updates without "tabbing"

[Roo Murray]

Hi

Is there an event procedure that will update fields within a form without having to tab out (or click out) of the combo box?

Thanks

Roo (New Joiner!!)

 

[ghudson]

The AfterUpdate event of the combo box will do it.

 

[Roo Murray]

I still seem to have to click out of the combo box for the form fields to update though. What I was really after is the fields to update on change of the highlighted record of the combo box.

 

[jtkjames]

If the user clicks an item in a drop down list, they trigger the On Change event.

However, if they enter text, they must press return to trigger On Change.

So you could use OnChange if you force the user to click a value

 

[Roo Murray]

I think it is a mixture of both - Typing in the combi box then scrolling down to the specific record. I've put event procedures in both _onchange and _Afterupdate but still no luck

 

[jtkjames]

Try On Lost Focus and On Exit.

Those are both triggered when the control loses focus (either on the same form or on another form, respectively).

 

[ghudson]

That does not make sense. If the user changes the value of a combo box, whether they move the focus off the combo box or not, the after update event of the combo box will be triggered.

 

[Roo Murray]

I'm looking further into this issue (as I didn't build this one myself) - What they have done with the expessions is call macros rather than code the updating directly. Would this cause the problems?