Recent content by GMP1978

Thank you very much... it was very close.. I just added +1 to the end of the code and it works perfect. Thank you!

I have a form that just became corrupted and I am attempting to rebuild, but I cant get one last piece. The form has 4 fields -Guidance Source Identifier -Calendar Year -Guidance Type -Sequence Number The first three fields the employee keys in the document number, the 2 digit year, and the...

I did something like Me!Sequence Number = (DCount("[Document Number]"= I cant remember the rest

I don't really understand this. I actually created this database 2 years ago and had it working but today an employee opened it up and it was corrupted so I am rebuilding. I had it set up so the Command Button could be clicked and it populated the next sequential number in the form based on...

I am trying to use the expression building on a command button to build a sequential button that looks at the document id field and when you click the sequential number command button it populated the sequential field with what version of the document this is (based on what is in the database...