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!
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!