how to write event procedure in access to make forms more

[Taneka]

Do you know how to go about writing event procedures in access to make individual forms more
manageable. As with getting through a form without having to go through each
question. Or setting tabs to each question based on answers choosen

Example:

Question 2 is a yes/no question: if yes go to question 3(drop down menu) and
then question 4(description) and choose answer, If No skip to question 5.

And all this to eliminate type errors.?????


I need to set the tabs and hide questions that are not needed based on
answers to a questions. I know I have to use macro for it but I just can't
figure it out.

 

[PHV]

Take a look at the SetFocus method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Nancy2]

code for after update of Question 2

If Question2 = True Then
Question3.SetFocus
Else
Question5.SetFocus
End if

 

[Taneka]

Thank you very much PHV and Nancy2 I will try it.