Find Value in Qry results Table and return all matching Rows from other Tables

Hi Forum,
I've been trying to create a Search DB where the User enters a Search Term, which then searches for matches across several Columns in a table.
There are other tables linked to the DB and the results located should also include all fields from the other tables.
I've created a mockup DB for the purpose.
Thanks for any suggestions.

While you have provided both the DB and a copy of the excel file you have linked, when downloaded, the DB is looking for the excel file on your machine. You would have been better served loading the data into the db in this case rather than link them.

Cannot test your query without relinking the files.

Help us to help you by making it easy for us and not make us work to solve your issue.

Thanks Alan, that's a good point.
I'll redo & update.
Peter

I've uploaded the DB with the Excel files imported rather than linked. Hope this helps.

What seems to be your issue. Your query appears to work as designed. My only suggestion to the query would be to create a parameter rather than hard code the lookup in the query itself. I am not sure how your form works as it does not appear to be linked to the query

I'm looking for the VBA that will do this. I've mocked up the search button to go to the Macro so that someone may know the best way to do this.

I'm looking for help to write the VBA to connect the query to the Form, I wanted to do as much as possible before I asked for help. Thanks Peter

before any vba can be written, you need to bind the form to the query if you are looking for the results of the query to appear in the form. You should not have an unbound form for this type of scenario. Once that is in place then it is a simple macro to trigger the query. Got to walk before you can run.