macro goto

[Guest]

I have an access database that has sections in the form, if the answer to the
first section question is no, i would like my form to skip that section and
either leave it blank or insert "No" in the following questions of that
section and then go to the first question of the next section. I presume i
have to use the goto command but i have never done any macro or commands
before, i have ECDL training but not the advanced training, could anyone help
me out?

Thanks in advance

Val

 

[Guest]

You'll have to write code in each control's AfterUpdate event. They will be
simple evaluations that use the .SetFocus method of the control you want to
move to. For example,

Private Sub MyControl_AfterUpdate()
If Me.MyControl = False Then
Me.MyOtherControl.SetFocus
End If
End Sub

It also depends on what type of control your first control is. The value
could be a text value, a checkbox, an option box, combobox, etc. This will
determine how you evaluate its value.

HTH,
Barry