I have a form where a user can select anywhere from 1 to 20 "products" (1 at a time). Once they select a product from the combo box and click the "add product" button, the item is added to a sub form that acts kind of like a shopping cart.
One of the options then becomes for them to View the product details. The details are found in each product's associated Word file. Based on a seperate table, when the user selects the product, it's file path name is stored.
SO, now I have a table filled with 1 to 20 paths (C:/Files/Product1.doc... etc) I can succesfully open one file using: Call Shell(stAppName, 1) where stAppName is defined by the path above. But what I can't figure out is how to open all the files if the user selects multiple products. They can be opened all at once, it doesn't matter. I just don't know how to loop through table (Products_Slct) records and call each path.
How do I move record to record and pull out the path names?
Thanks as always,
Marco
One of the options then becomes for them to View the product details. The details are found in each product's associated Word file. Based on a seperate table, when the user selects the product, it's file path name is stored.
SO, now I have a table filled with 1 to 20 paths (C:/Files/Product1.doc... etc) I can succesfully open one file using: Call Shell(stAppName, 1) where stAppName is defined by the path above. But what I can't figure out is how to open all the files if the user selects multiple products. They can be opened all at once, it doesn't matter. I just don't know how to loop through table (Products_Slct) records and call each path.
How do I move record to record and pull out the path names?
Thanks as always,
Marco