CompAnalyst
Programmer
Ok... i am feeling like an idiot. I am a self taught Access VBA developer and I am trying to get a string value to be passed to a report. Basically the user makes a selection of which report he wants to run, and I want the proper title to populate in the Report. I thought the way to do this was first to create a global variable in the general section and depending on what the user selects, it sets that string. I can get it to do that, now the problem is getting into the report. When i use a public function to basically get the info into the report it prompts me for the value of the function (aka a Parameter Value).
This is the code i had been working with:
Public Function fReportTitle() as String
fReportTitle= gReportTitle
End Function
then i set the control source of the text box in the report to =fReportTitle()
Argh what am i doing wrong?????
This is the code i had been working with:
Public Function fReportTitle() as String
fReportTitle= gReportTitle
End Function
then i set the control source of the text box in the report to =fReportTitle()
Argh what am i doing wrong?????
bear with me if u will... i am trying to get it to populate a field (is currently a text box, but perhaps it's a label) with a count of records from the previous quarter.... know any brilliant ways to do that? I would assume its a function that gets stuffed in there once it gets a count... but based on my previous luck with getting a string to populate i dont have much hope.....
