Auto increment in each click

[muhtady]

Hi all

I have an access db that has some forms to be printed to see a result of some db entry , now i want to do that :

when i click on the print button in the form , the printed page contain the number of movement (Auto increment in each click, and the result is shown on the printed page, then in a new day return to zero "reset to zero")

thanks in advance

 

[muhtady]

thanks for reply , but do you have any code for it ,
or can i put any specific code in "Count(*)", cause i don't have a clear understand for the situation u mentioned

 

[muhtady]

Ok , that's good until now , u put me to the first step of solution ,,,, thank u very much

 

[dylan_dog]

In the click event for your button:

counter.Value = counter.Value + 1 (counter is the name of the text box that holds your number) then
run update query to write counter value also to your table, so that you can retrieve the right number when you load the form