Use of global veriable in access 2003
Posted on 2012-08-28
I have access form with 10 command button and each button has a unique name.
I want to pass the information to other form which form has been pressed. To do that On click event I want to use a Global veriable and initialize the button name to that global veriable for example "A2345"
While a button pressed it will open another form and check which button has been pressed from that global variable do some action then clear the veriable for next use.
Please advise how to set up the global veriable for this purpose, example VBA code would be highly appreciated.
Thanks for prompt advise.