Populate an unbound text box on report

[AccessHunter]

Hi,

I have an access report whose control source is a table. The report is opened via vba code.There is also an unbound text box (named - PassedonParms) on the report. In the vba code I have a variable to store the parameters passed on to the table. On the report I want to display the value of this variable. For that, in my vba code I said, PassedonParms = Variable. Its not displaying anything. Please help

Thanks

[Stewart Ross]

Hi AccessHunter. There isn't enough information in your question to be sure what is going on. It has nothing to do with the use of the textbox. If you set a breakpoint in your code and check the value of the local variable concerned you will most likely find that it has no contents at the point at which it is used to set the textbox.

Are you using a global variable (global to that form's code module anyway) to hold the parameter string? If you are, it should be in scope at the time - but as you have not posted the code concerned I can't tell what might or might not be happening.

Presumably you have set the value of the variable concerned in the form's On Load event handler.

I'd suggest that you post the code that is used to set the value and the code of the local subroutine setting the textbox so that we can advise you in more detail about what may be happening.

-Stewart