Public Variables

[johny678]

I want to use a public variable called myFilter which takes values from a form called searchForm and then use it in another form to produce a report with the same filter. The problem is that I cannot make my variable work as public although I declare it in the General level. Any tips or even examples would be appreciated!!!
Thanks.

 

[Mile-O]

In which module are you declaring it public? You can't declare it in a Class module - i.e. the module that accompanies a form or report.

 

[Uncle Gizmo]

I think what you are referring to is generally called "a global variable" these are frowned upon in programming, as they can lead to serious bugs in your code.

Most things that you would imagine doing with a global variable can be done with a public function.

I would suggest that you post the code, and I'm sure someone will be able to make a suggestion.

 

[ghudson]

You could use a global string.

Option Compare Database
Option Explicit
    
Global gsMyFilter As String

Public Sub Test1()
 
     gsMyFilter = "ABC123" 'set the gsMyFilter value
  
End Sub

Public Sub ConfirmTest1()
 
     MsgBox gsMyFilter 'simple test
 
End Sub

 

[johny678]

Where should I declare it then if not in the General level of a class of a form?
Does the word Global works? Cause it gives me a compile error?

 

[ghudson]

Create a new public module. Click on the Modules tab and then click the New button. Do not give (save) your module the same name as a function or sub. Copying and pasting my code above into a public module [not a Class form or a Class report module] will work as-is for a quick test.

 

[johny678]

Done it! Thanks! So I will have a module just to declare my public variables (when need ones)??? Great!!!