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

Add a new line of list boxes in form view

P: 12
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.
Nov 9 '11 #1
Share this Question
Share on Google+
2 Replies

Seth Schrock
Expert 2.5K+
P: 2,951
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.
Nov 9 '11 #2

Expert Mod 15k+
P: 31,709
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.
Nov 12 '11 #3

Post your reply

Sign in to post your reply or Sign up for a free account.