Solved Display sub form Data on Select (1 Viewer)

robsonma6244

New member
Local time
Today, 17:44
Joined
Apr 1, 2020
Messages
4
Hi
I have a Form that displays the staff information.
To the right is a Subform to the left is some of the table fields that the use can select to change,
I would like the user to select the name from the sub form on the right and display the information on the left, Click the Save button then i can select a new person from the right and again want to it display the new selection to the left.
I hope that makes sense!
Screenshot_1.jpg

Many thanks
Mark
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:44
Joined
Oct 29, 2018
Messages
21,358
Hi Mark. Welcome to AWF!

Have you considered using a Split Form? Just curious...
 

robsonma6244

New member
Local time
Today, 17:44
Joined
Apr 1, 2020
Messages
4
Thank you,
Yes Split form works perfect but the design did not look so good, i wanted the design how i have it and not have the items as the Split displays it, I know it can be moved to the side, top and bottom but i just looked terrible.
 

Gasman

Enthusiastic Amateur
Local time
Today, 17:44
Joined
Sep 21, 2011
Messages
14,045
Search here for Emulated Split Form
 

robsonma6244

New member
Local time
Today, 17:44
Joined
Apr 1, 2020
Messages
4
From what i can see i think this would work ha ha now to try and get it to work in my database! :confused:
 

Gasman

Enthusiastic Amateur
Local time
Today, 17:44
Joined
Sep 21, 2011
Messages
14,045
Easy to implement. Two lines of code pretty much does it all, in it's simplest form, which is all I have had to use.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 01:44
Joined
May 7, 2009
Messages
19,169
see this demo
 

Attachments

  • SleepWell.accdb
    872 KB · Views: 104

Users who are viewing this thread

Top Bottom