Populate text box with output parameter from stored procedure

[HezMac]

Hey

This seems like a silly question, but here it is:

I'm trying to populate a textbox in a VB 6 app with an output parameter from a stored procedure and I'm not sure how to set the value or where to set it.

I call the procedure from a module and can debug.print the result fine... do I set the txtbox on the module or on the form?

I've tried:

cmdTestCount(Click)

Call the procedure

txtTestResult.Text = PrmTestCount
(where prmTestCount is the result from the SP)

And I get a "Variable not defined" error.

Thanks for any advice.

 

[CubeE101]

For a TextBox (Text1) on a Form (Form1)

You call set it from the form such as:
Text1.Text = "some string"

Or from a module such as:
Form1.Text1.Text = "some string"

I assume that is what you are asking...
If not, you might try rewording your question to be a bit more clear, or give a full example (like a clipping) of your actual code that is giving you the trouble, instead of a few random lines...

Visit My Site
PROGRAMMER: Red-eyed, mumbling mammal capable of conversing with inanimate objects.