Best Design Approach (1 Viewer)

MatthewB

Member
Local time
Today, 10:03
Joined
Mar 30, 2022
Messages
50
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
Tomorrow, 01:03
Joined
May 7, 2009
Messages
16,438
use Split Form (no or minimal code required).
 

MajP

You've got your good things, and you've got mine.
Local time
Today, 13:03
Joined
May 21, 2018
Messages
6,371
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, 13:03
Joined
May 21, 2018
Messages
6,371
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, 20:03
Joined
Dec 7, 2018
Messages
352
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
Tomorrow, 01:03
Joined
May 7, 2009
Messages
16,438
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
Tomorrow, 01:03
Joined
May 7, 2009
Messages
16,438
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, 20:03
Joined
Dec 7, 2018
Messages
352
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
Tomorrow, 01:03
Joined
May 7, 2009
Messages
16,438
another suggestion.
 

Attachments

  • CompanyCategory.accdb
    704 KB · Views: 118

isladogs

CID VIP
Local time
Today, 18:03
Joined
Jan 14, 2017
Messages
16,251
@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, 13:03
Joined
Feb 19, 2002
Messages
36,369
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.
 

Users who are viewing this thread

Top Bottom