Dynamically add fields to form as data is input

[nchesebro]

Hello.



What I want to do may be well beyond the limits of Microsoft Access 2007, but I figured it was worth asking...

I am creating a database from the ground up, and thinking ahead to what the end forms will look like have me considering different options in designing my tables.

What I want to do, for example is, in a main form, have a subform for phone numbers, and another for emails. Since one person may have multiple phone numbers (work, home, cell) and emails (childs email, parents email, work email, school email) I would like to have a subform for each that, when a phone number or email address is inputted, another set of fields is added automatically ready to handle another number or email.

ie:

Phone Number
Type: [ Cell |^] Number: ([555]) [555]-[5555] ext.[555 ]
Type: [-Select-|^] Number: ([ ]) [ ]-[ ] ext.[ ]
Email Address
Type: [ Work |^] Address: [someone@e3xample.com ]
Type: [-Select-|^] Address: [ ]

I would like to have this displayed in form view as opposed to datasheet view for purposes of user friendliness.

Is this possible? If so, how do I go about tackling this?

[pbaldy]

Have you tried continuous forms view?

[nchesebro]

I have not. I will experiment with that...