Creating auto increment numbers from txt boxes?

[d9pierce1]

Hi all,
This is a two form question...

I have a simple mach up db i am practicing on (Attached),
I am trying on ProjectFrm to create a Project Number via cmdbutton. I am trying to use the DivisionNumber, Year (yy) and a random number.
Should look like this 02-20### (The division - yy random 3 numbers)
I cant seam to get it to work. I found the code and mod on line for a starter sample but cant get it correct for my desire. There is a error on misuse of null for starters.

On RFIFrm, I want that same generated project number to transfer to RFIFrm and then automatically generate the RFI number. That should look as 02-20452-001 and so on for each Project.
So If the project is Raising Canes then i should have RFI number of 02-20452-001, 02-20452-002 and so on but it should start with 001 on each RFI number depending on project. Such as if i


have Chuck E Cheese, then the incriment would start over...

This is just a sample db but i put the code in, just cant make it work correctly...Error both forms.

Thanks
Dave

ProjectIncrTest - Copy.zip

[ArviLaanemets]

Have a look at my responses to this post https://www.accessforums.net/showthread.php?t=65653

[d9pierce1]

thanks, will give that a shot
Dave

[moke123]

Dave,
Noticed you are using DLast in some of your code.
Here's a good article that explains why you may not get the results you expect

https://codekabinett.com/rdumps.php?...ted-result-set