What is the external program?  I would think how you pass it to that program would be dependent on it.

Hi Tom,

It is a program written in visual basic displaying certain information dependent on the selected customer. The program is attached to a button on the repetitive invoice screen. Now, we need to pass the Customer No to the program which  would then display the information about the customer.

Hi Tom,

It is a program written in visual basic displaying certain information dependent on the selected customer. The program is attached to a button on the repetitive invoice screen. Now, we need to pass the Customer No to the program which  would then display the information about the customer.

So is you question "How do I obtain the value needed from the Sage database?"  or "I have the value needed - how do I pass it to my visual basic program?"

I have the value needed- how do I pass it to the VB program?

That's going to be dependent on how you wrote your VB program.  Unfortunately I'm no expert in VB.  Hopefully someone else in the forum might be able to help.

In the past in other languages I have written code that passes parameters.  Typically it you have a command line like Myprogram.exe  myparameter1  myparameter2.   The the program code parses the parameters.

Set up the button linked to a MS Script / vbs file, and pass the variables.  Then you can start your VB program from the VBScript, with the values available in the script.