If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculate post and show number for every post
Hello
I have Form with list post and filter for searching by textbox. The scour for this form is query. I want make count number to know how many raw is on this post list and show with every post a number. I create a textbox and insert on it this code: =oppp(IIF(true;1;0)) And create a modul that looks as this: Option Compare Database Dim aaa As Integer Function oppp(sss) As Integer If sss = 1 Then aaa = aaa + 1 ElseIf sss = 0 Then aaa = 0 End If oppp = aaa End Function The problem is number work good then it starts just step increase when I move the list up & down. Even if I close the form and restart it or update the form, just larger number. Where the wrong on this is code or is there better idea to get the counter on form on MS Access 2007? Thanks a lot |
Thread Tools | |
Display Modes | |
|
|