variable NOT visible -Please help

[iamraja5]

Hi all
this is driving me nuts, please help. I searched the entire globe for answer.

I am using access 2007

Class1 I wrote these codes

Option Compare Database
Public status As String
Option Explicit

form1 has a button and it has these codes

Private Sub Command0_Click()
status = "I am a happy man"


End Sub

same form1 has a another button with this code

Private Sub Command1_Click()
MsgBox status
End Sub

when I click the msgbox is empty??? why this is not msg as "I am a happy man"
Please make me a happy man.

Raja

[weekend00]

try
Global status as string

[SoftwareMatters]

Fisrtly check the names of the 2 buttons.

Then check that they have an event linked to them i.e. put the form in design view and then right-click on the a button and select properties. Then on the event tab choose [Event Procedure] from the On Click drop-down.

If they are named correctly and the code is linked to them then make sure you click the buttons in the correct order.

[SoftwareMatters]

try
Global status as string

It should work with 'Public status As String' just fine.

[weekend00]

You did not mention you clicked command0 before you clicked command1. maybe this is the issue?

[iamraja5]

Hi
1. Global as string the class did not work, gave me a compile error.
2. yes, I clicked the comman0 and then command1
3. Drop down box properties, I am not using a dropdown menu?

still the msgbox is empty, any other methods or did I miss anything? Please help

[SteveH2508]

Option Compare Database
Option Explicit
Public status As String

Your option statements should come before your variable declaration - see above

[iamraja5]

Hi all
Tried the following
Class1
Option Compare Database

Option Explicit
Public status As String
form1 has a button and it has these codes

Private Sub Command0_Click()
status = "I am a happy man"
End Sub

same form1 has a another button with this code

Private Sub Command1_Click()
MsgBox status
End Sub

when I click the msgbox is empty??? why this is not msg as "I am a happy man"

Thanks again all

[SteveH2508]

What is the Class1 at the top?

Remove it and it should work providing your Command buttons are called Command0 and Command1

[iamraja5]

Thanks All
This worked, I was placing the codes in Class module, I removed the codes and entered them in the Module it worked. thanks every one for the support.

[RuralGuy]

Each form has it's own Class Module. It sounds like you were putting your code in a Standard Module rather than the Form's Class Module. Are you ready to follow the link in my sig and mark this thread as Solved?