Creating a dynamic form, how?

[vinlud]

Dear newsgroup,

For a fairly simple MS Access application I need to create a form to
enter a few fixed fields of customerdata and answer a unknown number of
Yes/No (radio button) questions. The questions are stored in a table X
and can be altered by the user. The answers of the fixed fields of the
form are stored in table Y, the answers (Y/N) of the unknown number of
questions need to be stored in Table Z.

Has anybody experience with this situation? I've tried to solve it with
a subform but afaics this is better suited for entering multiple data
items.

Kind regards,
v.

[Allen Browne]

The questions need to be handled in a related table, so they will be
interfaced with a subform (one question per line.)

For an example of this kind of thing, download Duane Hookom's sample At Your
Survery example database, and see the data structure he uses:
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane
It may be more than you need, but will point you in the right direction.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"vinlud" <vi****@gmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

Dear newsgroup,

For a fairly simple MS Access application I need to create a form to
enter a few fixed fields of customerdata and answer a unknown number of
Yes/No (radio button) questions. The questions are stored in a table X
and can be altered by the user. The answers of the fixed fields of the
form are stored in table Y, the answers (Y/N) of the unknown number of
questions need to be stored in Table Z.

Has anybody experience with this situation? I've tried to solve it with
a subform but afaics this is better suited for entering multiple data
items.

[vinlud]

Thank you, it looks promising!

Kind regards