Solved Display sub form Data on Select

[robsonma6244]

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!

Many thanks
Mark

 

[theDBguy]

Hi Mark. Welcome to AWF!

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

 

[robsonma6244]

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]

Search here for Emulated Split Form

 

[robsonma6244]

From what i can see i think this would work ha ha now to try and get it to work in my database!

 

[Gasman]

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]

see this demo

 

[robsonma6244]

Thank you so so Much Now Sorted