In Access, how do I set up a form pathway for field responses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mstoller213 - 04 May 2007 21:26 GMT

I need to create a path based on field responses in an Access form. ie if
the answer is no, then answer next field, if it is yes, then automatically
skip next five questions on form. The skipped fields or questions should
then gray out and become unanswerable.

Reply to this Message

Daniel - 04 May 2007 22:14 GMT

You need to code it.

You'd used the afterupdate event on a given control then use the setfocus
method to move the cursor to another control and use the Enabled control
property to control whether or not other controls remain active or not.

Signature

Hope this helps,

Daniel P

> I need to create a path based on field responses in an Access form. ie if
> the answer is no, then answer next field, if it is yes, then automatically
> skip next five questions on form. The skipped fields or questions should
> then gray out and become unanswerable.

Reply to this Message