Moving to a new field

[summer]

How do I set up an expression in a field saying I want to move to a different field that is not the next field? For example, my form has combo box "Reason Code" which gives a value in "Reason Description". How do I skip over "Reason Description" and go directly to the next cell I need to enter data in?

 

[Jerry Stoner]

On after update of cboReason Code put;
DoCmd.GoToControl ("Your Control Name")

 

[David R]

Simpler solution: Take Reason Description out of the Tab Order. Under the Other tab of Properties, change Tab Stop to No. I would also lock the field to prevent them from being tempted to mess with it.

HTH,
David R

 

[Jerry Stoner]

Duh. Thanks David .

 

[David R]

*grin* I know the simple solutions cause I'm self-taught. Not everything has to be done with code.

 

[summer]

Thanks for your help!