Question Basic/Simple Combo Box question

[dmo]

This seems like the most simple of problems but, I can't seem to find an answer from searching this forum or google searching.

I have a combo box which, when a selection is made from it, populates several associated text boxes. The functionality is fine. However, when I make the combo bok selection (i.e. I click on one of it's "records"), I have to then press the Enter button before the text boxes are populated. How do I have the text boxes populate as soon as I make the selection from the combo box (and skip the step of pressing the Enter button).

Note: if coding or macros are needed to accomplish this, I am a lot more proficient with macros than I am with coding and would prefer to use the macro-based solution.

thanks in advance for any help!

 

[CBrighton]

What event fires the current functionality?

There are various events which fire at slightly differnet times such as change, after update, before update.

I find an easy way to test which event would be better is to give each one a messagebox (e.g. give on change the following code: MsgBox "On Change")

Then select something in the combobox as normal and whichever messagebox is displayed exactly when you want it to be will give you the name of the event which you should use.

 

[dmo]

this worked. thanks.