I just cant get this to work. Everywhere I've read says it can..... I have attached a mock db with the form im trying to get this to work on. All im trying to do is get the default value for the pass to increment by +1 based on the date and passtype.
Can anyone help me see what im doing wrong so I can fix this in my real db.Database2.zip
Also, since no values would be present when the form loads, I doubt the default property will work. I'd put the value there at some other point. Also, all your data types are text, so need the delimiters shown in the link.
Okay so in my real database should I put the code in the subform, like it afterupdate in one of my child fields to the main form that i would put data in? or like gotfocus, since I want to tab down to get the next number to fill in?
Im also getting a compile error putting in the delimiters: