Add Sequential numbers

C

cirrusminor81

I have a tabel that I import that eventually prints checks on sheets (3
checks to a sheet). The checks are used in different applications so I
never know what the first check number will be until I procure the checks
from accounting. What I want to do is tell access what the first check
number is and it will fill the next check numbers sequentially until all the
fields are filled.

How do I go about this?
 
R

Richard

If your looking for code to increment numbers forward I have used this.

Private Sub Form_BeforeInsert(Cancel As Integer)
Dim strCriteria As String

Me.YourField = Nz(DMax("YourField", "YourTable", strCriteria), 10) + 1

End Sub

The next number would be 11.
 
Top