View Full Version : Moving to a new field


summer
04-18-2002, 07:13 AM
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
04-18-2002, 07:29 AM
On after update of cboReason Code put;
DoCmd.GoToControl ("Your Control Name")

David R
04-18-2002, 08:15 AM
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
04-18-2002, 08:21 AM
Duh. Thanks David .

David R
04-18-2002, 09:41 AM
*grin* I know the simple solutions cause I'm self-taught. Not everything has to be done with code.

summer
04-18-2002, 10:29 AM
Thanks for your help!