'Hiding' unused fields in a form

[MizLyn74]

I am working on a database (in Access 2007) that people will use to submit 'Event Reports'. There are two forms and on one of them there is a place to enter names and contact information for people involved....what I want is to have one set of fields visible but give them the option to add additional 'lines' (for different people) if they want to....the table has five rows for this information but I only want the necessary fields showing in the form...though I do use access a lot - it's usually pretty basic...is this even possible? And if so....how?

 

[CEH]

"People involved" is a little vague Are these multiple people who will have the same "Classification"? For example... 5 or 6 different people working at one location.... You might have 6 or 8 at your second location? If so you could do this with a subform or a linked form... Use datasheet or continuous view.

 

[boblarson]

This sounds like you don't have your table structure set properly (normalized). You should be having a main/subform setup where the subform allows you to add as many people as needed (not just five available). It sounds like you might need to post your table structure and then we can talk about the forms after the structure is sound.

 

[MizLyn74]

It's a Safety Program so the reporting would be done by an employee and the 'persons involved' could be anybody, additional employees, customers....or there could be none at all! We wanted the form to be as simple (and as small) as possible but give the opportunity to add more entries if needed....

 

[boblarson]

It's a Safety Program so the reporting would be done by an employee and the 'persons involved' could be anybody, additional employees, customers....or there could be none at all! We wanted the form to be as simple (and as small) as possible but give the opportunity to add more entries if needed....

I understand small and a subform could accomplish that but we really need to see what your table structure is like currently.