Q:

Access 2007 - Forms created on the fly

Hopefully I can find some words of advice from somebody.
Is it possible to create forms 'on-the fly' so to speak in MS-Access 2007
I have a structure of tables:
tblCustomer
tblQuestAns
A customer may answer the questionnaire answers many times as they relate to all products.
I propose to hopefully have an initial input form that will ask how many products of which there could be more than 1
eg: TV, Video (say the user selects 2)
On entering that data the next form should hopefully update itself to include the list of questions eg
TV
Q1, Q2 Q3
-
Video (1)
Q1, Q2 Q3
-
Video (2)
Q1, Q2 Q3
Is that possible? Any point in the right direction would be appreciated.
Thanks
Noel

A:

You'd probably want to do a subform with a variable number of records.

