how to include skip patterns in forms?

[NJarrett]

I'm working with Access 2003 and would like to create a form for data input
based on a pre-existing survey. This survey contains skip patterns -- ie,
if the answer to question 1 is Yes, skip question 2 and go to 3. I'd prefer
to program these skip patterns into the form in order to minimize error on
the part of the data entry clerk. Any tips, code, or instructive websites?

Thanks.

 

[fredg]

I'm working with Access 2003 and would like to create a form for data input
based on a pre-existing survey. This survey contains skip patterns -- ie,
if the answer to question 1 is Yes, skip question 2 and go to 3. I'd prefer
to program these skip patterns into the form in order to minimize error on
the part of the data entry clerk. Any tips, code, or instructive websites?

Thanks.

You might try coding each control's AfterUpdate event:

If Me![Control1]="Yes" Then
[Control3].SetFocus
Elseif Me.[Control1] = "N/A" Then
[Control4].SetFocus
Else
[Control2].setFocus
End if

If there were a considerable amount of choices on any one control use
a Select Case statement instead of If..then.