Ok, Are you sure that is form? Try it like this: Forms!formname!controlname = Nz(DMax(“[Claim Reference]”,”tblWarrantyClaims”),0)+1 Use the actual form and control names. it is not a good
Read my blog on Securing the Back End But frankly, if you have people who will try to get past the front end, then you have a bigger problem. I have well over 100 Access apps and I don't use extraordinary
I would do it differently. DoCmd.OpenForm "frmTimEntry",,,,acAdd Then, on frmTimeentry I would set the default value for txtValue2 to Forms!frmLogin.txtValue1. The problem is likely that the
You can open the form in Add Mode and then assign values to the controls. Or you could set the default value to read from the referenced control.
Don't use .Value. first it its the default value when referencing a control on a form and that's not what you are doing. You are referencing a variable passed to the procedure. You should be using: