MS Access 2010 - Find specific data in a linked Excel sheet

[Wingfoot]

Hi

I was wondering if it would be possible to click on a particular field in an Access form (where the field contains a reference number), which then opens a linked excel sheet and finds the same reference number in that sheet.

The way I envisage it working would be like a hyperlink to a specific excel sheet, followed by a process to perform a search to locate the criteria from the form field - if that's at all possible!

Hope that makes sense, if not please let me know and I'll clarify.

Thanks in advance.

 

[alansidman]

Why not just run a query in Access that looks at the linked table and returns the expected results for the needed fields?

 

[Wingfoot]

Hi Alan

Thanks for your reply - is it possible to run a query by clicking in a form field though?

 

[Wingfoot]

Don't worry - I've solved it by creating a form from my linked table and using the on-click event on the field in my main form to open the form, using the "where" condition as follows:

DoCmd.OpenForm "FrmName", , , "ID_ Number = " & Me!ID_ Number