Selecting record from subform and showing in mainform (1 Viewer)

Andyconc

New member
Local time
Today, 14:22
Joined
Jul 28, 2014
Messages
2
Hello Guys,

This is my first post here so I would just like to thank you in advanced for your help!
I'd also like to apologise, I am sure this has been covered before but I have had no look locating the solution. (or indeed knowing how to phrase my question when on youtube or google to get to the answer)

My Database is really simple, it contains 1 table (called Querys) and a form called Dashboard.

In my main form (Dashboard) I have inserted a sub form which shows all the records in my table (called Querys) when I use my main form and add a record this sub table can then be refreshed and it shows all my records.
This part is fine,
What I would like to do is be able to select a record in my sub form and it show the record data in my main form. This would really speed up the navigation process as the database gets bigger.
If I'm going about this in completely the wrong way they please advise.

Thanks for your help.
Let me know if uploading my database will help and ill sort it out!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 07:22
Joined
Aug 30, 2003
Messages
36,118
What Access version do you use? The newer versions have a "Split Form" that does what you describe.
 

Andyconc

New member
Local time
Today, 14:22
Joined
Jul 28, 2014
Messages
2
Im using 2013, and the split form is working a treat!! thankyou so much
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 07:22
Joined
Aug 30, 2003
Messages
36,118
Happy to help, and welcome to the site!
 

Users who are viewing this thread

Top Bottom