Create skip pattern in MS Access Data entry from

[Nadine]

I would like to know if it is possible to create skip pattern on a MS Access
data entry form and how does that works.
Thank you

 

[TonyT]

Hi Nadine,

I guess it depends on the complexity, and number of questions / related
questions as to how easy it is to accomplish. Forcing cursor movement around
the screen, hiding and revealing textboxes and labels and coding default
values into 'un-entered' textboxes is simple enough with Access & vba.
The route I have seen used a few times is to have your *primary* questions
down the left hand side of the form, and then the sub-questions *revealed* on
the right if the relevant value is selected from the combobox on the left.
But equally, subforms can be used if there are many sub-questions. It also
depends on the number of tables used to store the data, and how they are
linked together.

hope this helps,

Post back if you start and run into any specific problems,

TonyT..

 

[missinglinq via AccessMonster.com]

If by "skip pattern" you mean change the order in which the contols are
tabbed thru, this is straight from Access Help:

Open the form in Design view.

On the View menu, click Tab Order.

Under Section, click the section you want to change.

Do one of the following:
If you want Microsoft Access to create a left-to-right and top-to-bottom tab
order, click Auto Order.

If you want to create your own custom tab order, click the selector for the
control you want to move. (Click and drag to select more than one control at
a time.) Click the selector again and drag the control to the desired
location in the list.
Click OK.

Switch to Form view to test the tab order