Originally Posted by
ssanfu
I was introduced to a form design like this many, many years ago. The details section is in continuous form view of the main table.
There are list boxes that are activated/updated are cascading list boxes.
So you would start out by selecting a client in the details section. The first list box "1 - Division" is updated. Selecting a record in that list box updates the following list box...... Double clicking a list box brings up a details form.
The buttons (some are text boxes configured to act like buttons - able to change bg colors) bring up forms for different actions.
I used to use a main form with a lot of buttons, but the current design is better - data is instantly visible, can drill down by double clicking list boxes.
Many UDFs to provide values in the black section/ yellow text boxes.
List boxes show data, take up less space than sub forms and double clicking allows for form to be opened to add/edit/delete data, select reports or perform maintenance (if you have permissions).