Add a new line of list boxes in form view

[Gwyn Jones]

My scenario:

I have a line of list boxes under the headings "Company", "model" and "serial number". A drop down menu selects the value for this which is linked to a table. The values in the lists can be updated via a seperate form which also links to the table.

The problem:

As different customers will have different amounts of products, I would like to be able to create a button which generates a new line of list boxes beneath each previous one, shifting everything else in the form down to allow space.

Is this possible in on Access?

Or can anyone recommend a better way of doing this?

Many thanks.
Gwyn.

[Seth Schrock]

I think what you need would be a subform on your main form. You can do this a couple of ways depending on your needs. You can either put the subform on your customers form or you can create a form for your sales. Based on your choice, you will need to create a table using the fields you mentioned plus either the CustomerID or the SaleID. This field will then be what links the subform to the main form. For the subform, all you have to do then is make it be in datasheet view and then you will have all the lines that you need with each one having the combo boxes to choose your values.

I hope this makes sense.

[NeoPa]

Gwyn, I would suggest you look at some of the form wizards Access has available. Your thinking seems to indicate a lack of appreciation for what Access does for you. The route you suggest is typical of those who come into it with ideas from other systems and try to impose them on Access rather than learning the basics of Access first and allowing it to work its magic for you.