Is it possbile to click a btn to run a query then follow a hyperlink?
On my form is a part #. Each part has a drawing associated with it. The drawing file is located on a server. The location of the drawing is stored in the part table. My form's control source is QA_tbl. I have a query set up using the Part table and the QA_tbl. Using the Part # from the form and I can find the drawing location. I would like to be able to run the query and then follow the link so the drawing file opens.
On my form is a part #. Each part has a drawing associated with it. The drawing file is located on a server. The location of the drawing is stored in the part table. My form's control source is QA_tbl. I have a query set up using the Part table and the QA_tbl. Using the Part # from the form and I can find the drawing location. I would like to be able to run the query and then follow the link so the drawing file opens.
