Best Design Approach (1 Viewer)

MatthewB

Member
Local time
Today, 05:04
Joined
Mar 30, 2022
Messages
85
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
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:04
Joined
May 7, 2009
Messages
19,169
use Split Form (no or minimal code required).
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 08:04
Joined
May 21, 2018
Messages
8,463
This one is popular and is more customizable than the standard split form.
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 08:04
Joined
May 21, 2018
Messages
8,463
You can reconfigure the above approach and put list part and detail part side by side instead of top to bottom.
 

Eugene-LS

Registered User.
Local time
Today, 15:04
Joined
Dec 7, 2018
Messages
481
what is glitchy about it?
you think and explain!
Split Form has duplicate fields at the top and bottom, and events of objects works on the top only - and that's not all
This confuses the users and doesn't let them work properly
Is that enough for you?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:04
Joined
May 7, 2009
Messages
19,169
Is that enough for you?
if it is Confusing to you, don't use it.
what i am Suggesting to the OP is possibility.
I am not Enforcing anything as if it is the Ultimate Absolute solution!
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:04
Joined
May 7, 2009
Messages
19,169
obviously you Liked post #3 which is an emulation of split form
and on your own word will confuse the user because of the layout?
 

Eugene-LS

Registered User.
Local time
Today, 15:04
Joined
Dec 7, 2018
Messages
481
obviously you Liked post #3 which is an emulation of split form
and on your own word will confuse the user because of the layout?
No, I have my humble opinion based on experience, and I am ready to prove it by examples
...
 
Last edited:

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 20:04
Joined
May 7, 2009
Messages
19,169
another suggestion.
 

Attachments

  • CompanyCategory.accdb
    704 KB · Views: 241

isladogs

MVP / VIP
Local time
Today, 12:04
Joined
Jan 14, 2017
Messages
18,186
@MatthewB
if you do decide to try my emulated split form (ESF), the current versions are available from my website:

The article outlines some of the ways in which the ESF provides more functionality than the standard split form
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 08:04
Joined
Feb 19, 2002
Messages
42,970
I prefer a filterable but not updateable list form with an editable single form popup. The popup is a dialog so code in the list form stops while the popup is open. That means that on the line after the OpenForm method, you would have a Me.Requery so the list form gets updated with any changes to the popup. If having the list form loose your current position is a problem, there are ways to solve that problem.
 

nycazngrl89lw

New member
Local time
Today, 05:04
Joined
Jul 5, 2022
Messages
1
  • Stage 1: Empathize—Research Your Users' Needs. ...
  • Stage 2: Define—State Your Users' Needs and Problems. ...
  • Stage 3: Ideate—Challenge Assumptions and Create Ideas. ...
  • Stage 4: Prototype—Start to Create Solutions. ...
  • Stage 5: Test—Try Your Solutions Out.
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 12:04
Joined
Sep 12, 2006
Messages
15,613
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.
 

Users who are viewing this thread

Top Bottom