running apps from forms

[don_black]

Hi,

Im running a very simple app from a link inside a Form - heres the code

stAppName = "D:\invoices\url2bmp.exe -url http://sandbox/customersinvoice.asp?ID=XXXX"

I need the ID field to be the same ID as them record that is selected

does anyone know what code i would have to put in there to make it change from record to record??

Thanks

Don

 

[freakazeud]

re:

Hi,
I assume you are using the shell() method with this.
If your code works so far with a hardcoded ID number then all you need to do is dynamically referencing the control which holds the ID number at the time of execution e.g.:

"D:\invoices\url2bmp.exe -url http://sandbox/customersinvoice.asp?ID=" & Me.IDControl

IDControl would be the control that is bound to the underlying datasource's ID field.
HTH
Good luck