How to automatically 'skip fields' when entering data in Tables?

[Eric]

Hi,

I'd be really pleased if anyone could give me some
feedback on this question:

In our database we decided not to use forms, but to enter
data directly into the tables from interview
questionnaires (filled out by the interviewer).

Sometimes, depending on what the respondent says to one
question (e.g. Yes or No), the interviewer 'skips' to
questions in another part of the (paper) questionnaire.

As a result, when data is later being entered into the
tables, the data-enterer has to 'skip' to different fields
depending on how questions have been answered on the
questionnaire.

How can I make the data-entry process more efficient and
more accurate by:
a) having Access automatically 'skip' to the correct
field/question depending on what the data-enterer enters
in certain fields (e.g. if the question is: "Are you a
smoker" and data enterer enters 'YES' for this field for a
certain record, Access should automatically go to the
beginning of the series of fields related to 'smoking' -
so that the data-enterer can continue entering data there,
otherwise it would skip this set of questions and go to a
different field/question ...)?

b) having certain fields 'blocked' from data entry, so
that the data-enterer won't put information in their
accidentally..

(e.g. if the question is: "Are you a smoker" and the data-
enterer enters 'No' for this field for a certain record,
access might automatically skip this section, and
subsequently not allow the data-enterer to enter anything
in the 'smoking section' fields of the table.)

Can I use a Visual Basic macro of some type?

Thanks in advance for your help!

Eric

 

[Cheryl Fischer]

The things you want to do require the use of forms. There is no capability
in tables, which are simply repositories for your data, to create the code
needed to evaluate user input and then perform some other activity.

 

[Tim Ferguson]

In our database we decided not to use forms, but to enter
data directly into the tables from interview
questionnaires (filled out by the interviewer).

As Cheryl says, this is a bad decision, and one you really should
reconsider.


B Wishes


Tim F