Unsolvable

[tedward]

Hi Folks,

My form has a field for Year Date and another for Record Number. My first record needs to begin with 1 on Oct. 1st and auto reset to 1 each Oct 1st with the new fiscal year. Auto changing the fiscal year is a snap. Auto resetting the record count seems to allude me everyone else. Anyone have any idea how to auto reset the record count? Thanks in advance for any help.


If Date < DateSerial(Year(Date), 10, 0) Then YearDate = Year(Date)
If Date > DateSerial(Year(Date), 10, 0) Then YearDate = Year(Date) + 1

If Date > DateSerial(Year(Date), 10, 0) And ID = DLookup("ID", "tblYearDate", ID > "") Then
'ID = Nz(DMax("ID", "tblYearDate")) = 1
End If

ID = Nz(DMax("ID", "tblYearDate")) + 1
End Sub

 

[Abeiis]

Counter reset

Hi,
The quick way is to create a staging area, by this I mean, create a form with Unbound fields to check a flag for Oct. 1st and enter "1" in the counter ID field ([IDfield]=[IDfield]+1), then add the record to the table.
Hope this helps or open the way to think or other options!