hello All
I have a main form and sub form both are connected to the same table and design as below:
I would like to show all the records on the sub form, and when i click one of them show its details on the main form
Regards
show details on main form when you click on subform
-
- BronzeLounger
- Posts: 1239
- Joined: 01 May 2016, 09:58
show details on main form when you click on subform
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: show details on main form when you click on subform
Select the table in the navigation pane.
Activate the Create tab of the ribbon.
In the Forms group, select More Forms > Split Form.
Once the form has been created, switch to design view and modify the design as desired.
Activate the Create tab of the ribbon.
In the Forms group, select More Forms > Split Form.
Once the form has been created, switch to design view and modify the design as desired.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: show details on main form when you click on subform
Alternatively: open the main form that you already have in design view.
Set the Default View to Split Form.
Lower down on the Property Sheet, set the Split Form Orientation to Datasheet on Bottom.
Set the Default View to Split Form.
Lower down on the Property Sheet, set the Split Form Orientation to Datasheet on Bottom.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 111
- Joined: 22 Feb 2022, 09:04
Re: show details on main form when you click on subform
That is what I call an Emulated Split Form or ESF.
I created one for a DB of mine many years ago.
In the main form Open
sfrmEmails is the subform control
In this you do NOT link the master and child fields.
However that does not appear to be how Isladogs has done it.?
https://www.isladogs.co.uk/emulated-spl ... t%20works.
I created one for a DB of mine many years ago.
In the main form Open
Code: Select all
Private Sub Form_Open(Cancel As Integer)
Me.RecordSource = "qryEmails"
Me.sfrmEmails.SourceObject = "cfrmEmails"
Set Me.sfrmEmails.Form.Recordset = Me.Recordset
In this you do NOT link the master and child fields.
However that does not appear to be how Isladogs has done it.?
https://www.isladogs.co.uk/emulated-spl ... t%20works.
Using Access 2007/2019.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.
-
- BronzeLounger
- Posts: 1239
- Joined: 01 May 2016, 09:58
Re: show details on main form when you click on subform
Thank you Gasman and Hans, based on your replies an idea came to my mind... I have used a continues form only and I have added the fields again to the Form footer of the continues form as below :( so I liked to share this with you as well )
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78558
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1239
- Joined: 01 May 2016, 09:58
Re: show details on main form when you click on subform
Thank you for you all :)