Check boxes and forms

[John Memorex via AccessMonster.com]

I am new to access and databases in general, so forgive me if my questions
seem elementary. I would like to create a form with a series of check boxes
for questions for potential clients (i.e. Married ?, Children?, Pets ?,
Languages?, etc). Selecting the box would then take the prospect to forms
specific to their answers on the intake form. There may be 25 - 30 questions
on the intake form, however the client may select all or only a portion of
the check boxes.

If they select Children. I'd like them to get a form to input data for each
child. However, if they select a field such as language or other simple
field, I'd like that field to appear on a form with other simple fields. As
there are several simple fields that can be randomly selected, I'd like to
have the form created dynamically based upon the clients answers on the
intake form.

Is this possible in access? I don't want to create an individual form for
each question. Again I apologize for my inexperience.

John

 

[Guest]

yes it is possible

you will need vb code

not knowing the specifics of what combination of 'yes' = which form ...so of
course not able to say how in detail...but more or less it probably is an
If/then or Case select style coding in vb

 

[John Memorex via AccessMonster.com]

Thank you for the fast response. As I am new to all of this vb = Visual
Basic? I don't know how to code VB. Is there a resourse you can point me to
that explains how to do what I am trying? Thanks for the help.

John

yes it is possible

you will need vb code

not knowing the specifics of what combination of 'yes' = which form ...so of
course not able to say how in detail...but more or less it probably is an
If/then or Case select style coding in vb

I am new to access and databases in general, so forgive me if my questions
seem elementary. I would like to create a form with a series of check boxes

[quoted text clipped - 15 lines]

John