I want to "pass over a field on a form without entering data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data entry form that in certain circumstances I wish to quickly by
pass three fields that are not relevant with some entries, is there a way
that these fields can be auto tabbed with no information entered, I know in
"cough" Alpha 4 I used to use a "Skip" control that did just what it said,
anybody any idea's Please.
 
How do you know that you want to skip sometimes and not others? Can you
tell Access what conditions exist for this to happen? If so, you could add
code behind the control that precedes the skippable fields telling Access to
go to the next (appropriate) control.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
In the properties sheet for the form fields under the tab 'Other' set tab
Stop to NO and it will skip the fields but allow you to click into them with
your mouse and enter data. hope this helps.
 
In whatever field you would have put the skip put
me.fieldname.setfocus ---- fieldname being the field you want it to
skip to.

Ron
 
Back
Top