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