ONDIRTY MOVE TO NEXT FIELD

[Bonnie]

Hi,

I have a combo box, when I hit Y (yes) I would like to save a keystroke and
have the cursor move to the next field. How would I do that? I tried
ONDIRTY but it gave me an error and couldn't move.

Thanks in advance,

Bonnie

 

[Ken Snell \(MVP\)]

Try the AfterUpdate event of the combo box.

 

[Bonnie]

Wouldn't that be the same thing as hitting enter or tab - I am trying to
avoid that extra keystroke. If I am in the field and key 1 (which is one of
the options in the combobox) I would like it to move to the next field
without having to key enter or tab.

Thanks.

 

[Ken Snell \(MVP\)]

AfterUpdate event of the combobox occurs when you click an item in the
dropdown list, or when you type something into the combo box and then press
tab or enter. If you want the action based on typing in a single letter,
then you can use the Change event of the combo box... but it will occur as
soon as the first character is typed into the combo box, so be sure that you
test the entered value (using the Text property of the combo box, not the
Value property) before moving the focus to where you want it to go.

 

[Bonnie]

Oh thanks Ken. I don't know why but it didn't fire when I hit the character.
I hit Y for yes and it didn't move. I'll try again or test out the Change
event.

Thanks,

Bonnie