Hi all!
I have a simple access form. It as a command button. When I click the command button on the form, the first form closes(dcmd.close), another form opens(docmd.open) which again has a command button. When I again click the command button of this form, the form closes and a new form opens. There are 30 forms in total, with 1 command button in each form. What I need is at the every click of command button a integer variable should have increment +1 so that at the end I can cout the total no. of forms or command button.

Create a module with a Public variable declaration, and then refer to that variable with each button On Click:

'---
'Module
Dim Public myVariable As Integer

'myVariable = ? default is 0
'---
'On Click
myVariable = myVariable + 1

HTH


mmcdonal

I think the syntax is "Public myVariable As Integer," not "Dim Public"

mmcdonal