My database has two primary forms. The first form has a group of command buttons that allows me to select a plant. Clicking on one of the command button opens the second form, which contains information about that specific plant. I achieved this selection by writing a macro for each CB on the first form. Each macro contains a plant specific identifier (one macro – one plant) and the macro opens the second form. The control source for the second form is a select query that returns plant specific data.
Now I would like to use a CB on the second form that runs an application to open a *.pdf file. How do I pass the plant identifier to the macro so the desired graphic is opened? I tried setting the “where condition” of the macro to the plant identifier but this approach only opens the first instance in line. Thanks.
Now I would like to use a CB on the second form that runs an application to open a *.pdf file. How do I pass the plant identifier to the macro so the desired graphic is opened? I tried setting the “where condition” of the macro to the plant identifier but this approach only opens the first instance in line. Thanks.
