Update text box based on combo selection

[Guest]

Using Office 2003 and Windows XP.

I have a combo box on a tab control; also on this same tab is a text box.

Both controls are UNBOUND.

When the user changes the combo box, I would like to update the text box
with corresponding information based on the entry selected in the combo.

Also, I need to allow for the user to enter a new entry into the combo, in
which case a generic entry will be added to the text box.

I can code this, but which events, etc. do I use?

I get an error using After_Update; On_Change works, but then typing is
affected (have to pause in between each character).

Can I obtain some suggestions for this procedure?

Thanks much in advance.

 

[Marshall Barton]

Using Office 2003 and Windows XP.

I have a combo box on a tab control; also on this same tab is a text box.

Both controls are UNBOUND.

When the user changes the combo box, I would like to update the text box
with corresponding information based on the entry selected in the combo.

Also, I need to allow for the user to enter a new entry into the combo, in
which case a generic entry will be added to the text box.

I can code this, but which events, etc. do I use?

I get an error using After_Update; On_Change works, but then typing is
affected (have to pause in between each character).

The AfterUpdate event is the one to use. What error are you
getting? What does your code look like?

 

[Guest]

Hi,

I get this error message:

Before_Update or Validation Rule property for this field is preventing data
from being saved in the field.

There is no Before_Update event set and there is no Validation Rule either.
Any ideas?

 

[Guest]

BTW, if I add: On Error Resume Next

It runs fine...

 

[Marshall Barton]

Add that to what? I can't make a decent guess about what
might be a problem when I can't see the code. I may not be
able to even if I could see it, but there's at least a
better chance than shooting in the dark.