Calling a public variable

[balistikb]

I have declaired a public variable to hold a value that is selected from a pop up form combo box. I would like to use that value to filter the records that open in the next form. How do I reference back to that variable and how do I use that to filter a form?
Here is the code that I have to take the value from the combo box and put it in the variable.

Me.project.Value = project_name_str
[\Code]

 

[Rolliee]

Place the public variable in a global module and just refer to it anywhere in your project. You should probably load in a default value at the on_load of the switchboard or main form.

rollie@bwsys.net

 

[balistikb]

Sorry I am still learning access but how do I call it if I want to use it?

 

[Rolliee]

As a global public variable, it can be set or called anywhere.

using a command button you could:

private sub command0_click()

msgbox MyPublicVariable



end sub

and it would be there.

rollie