I am working on an old Access system which now ties to a SQL Server Database. I am in the process of making a replacement system but in the mean time I have to support the old one.
The Issue is that we have numbers that are generated based on the Fiscal Year. Some where in the code some one has hard coded the years and I need to update it. I checked for a Trigger (which is how I would have done it) and found none. It seems that the programer did it on some kind of on insert event in the VBA code. I looked at the VBA behind the NEW button we have on the form and all it does is the following.
DoCmd.GoToRecord , , acNewRec
So there is code some where that is doing the number generation when a record is added. I want to find this code, remove it so that I can code a trigger which is the proper way of doing it. The problem is I have no idea where to look. Can some one help?