Getting variables from one function to another in VBA

[argsemapp]

I have a form with a couple of events scripted in VBA (an AfterUpdate on a combobox, another OnClick on a button). Basically I want to use a string variable from the AfterUpdate code, in the OnClick section of the code. How do I do this?

This string will be passed with OpenArgs to a report, if that makes a difference.

[argsemapp]

Actually dealing with this by moving the code from my AfterUpdate to my OnClick, but I would still like to hear how people would handle this kind of thing

[June7]

Options:

1. Global or Public declared variable - variable declared in module header

2. populate an unbound textbox on form - can be not visible

3. TempVars - I've never used them

4. custom collection - never done this either

[argsemapp]

Instead of passing the entire recordset I just passed the query for the recordset to the report. This seems to be okay for now but I can see myself having trouble bc this report will require multiple inputs from my form eventually...

[June7]

1. parameterized query using LIKE operator with wildcard, review:
http://datapigtechnologies.com/flash...earchform.html
http://datapigtechnologies.com/flash...tomfilter.html
http://datapigtechnologies.com/flash...mtoreport.html

2. VBA code to construct criteria string and set the form Filter and FilterOn properties, review: http://allenbrowne.com/ser-62.html
Or use WHERE CONDITION argument
DoCmd.OpenReport "reportname", , , strWHERE

[Dal Jeanis]

TempVars is a very good option, for reaosnable numbers of parameters.

Demo module was posted here https://www.accessforums.net/code-re...ars-36353.html