By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,034 Members | 960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,034 IT Pros & Developers. It's quick & easy.

Creating a dynamic form, how?

P: n/a
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.

Dec 14 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Dec 14 '05 #2

P: n/a
Thank you, it looks promising!

Kind regards

Dec 14 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.