If one has a contact list of 1100 companies grouped by service category it is useful to see a datasheet or list view, and a form view side by side. Then you can select from the list and see the company and employees in the form view. What is the best selection of controls to achieve this? One ideally wants a form view that can be updated. The one approach I have seen uses a query and a list box, but the form data would not update. It seemed odd as well that the form data required VBA to populate from the query. Your thought?
A Novice
Thanks
irrespective of the answers given here, the real issue is to think carefully about the data you have, and structure it in such a way that the solution is more easily found.
eg. If you have 1100 companies in your system, do you ever want to see all those companies, or do you want to first select a category or even multiple categories of those companies, to reduce the sample size. eg, if you can process the 1100 by a selection that reduces the number by a factor of 10, twice, you now only have 11 companies, and it's going to be easier to present those 11 in a more user-friendly manner.
You really don't want a list of 1100 companies. It's just too many to use comfortably, I think.