If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Clicking on a form to pop up and limit a query

Thread starter Andy959
Start date Feb 12, 2015

Andy959

Board Regular

Feb 12, 2015

Hey everyone,

I have a query that returns the top 20 records from a table. This query is nicely displayed in a form. I have a second table with more info for these records where I would like to pull data. What I would prefer to have happen is the user click on, lets say Record1 of the Top 20, and a new window pops up with only the Redcord1 info from the second table.

I can create the second query to pull the extra data for all Top 20 records, but I'm not sure how to integrate clicking on the record in the form to display just the associated data.

Any ideas?

Thanks!
Andy