Using MS Access/Skip Pattern

Advertisement


Question
Dear Sir,
         I want to know, how to use skip pattern in Ms-Access 2007 like if field A1=1 cursor skip to field A3.

Answer
You need to use the setfocus method. You first set focus to the form you are on that would be me dot set focus then set focus to the control you want to skip to which would be the name of the control dot setfocus. If the subform is involved for the control that you want to move to you would also have to set focus to the subform after first setting focus to the main form.
Bob Heifler
Www.myaccessprogram.com

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Bob Heifler

Expertise

ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING QUESTIONS 
Free Microsoft Access Tutorial Videos are available to you at my web site. Fifteen years of Microsoft Access experience allows me to answer most of your questions. Common question example files available here.

Experience

Microsoft Access programming since 1994. Support for all versions. www.myaccessprogram.com

Publications
My Microsoft Access articles are published at:DailyAccessTips.com

Education/Credentials
UCLA GRAD, Member of Association of Database Developers

Awards and Honors


Past/Present Clients
See some of my past clients here.

©2016 About.com. All rights reserved.