Forum Discussion
Issue with creating a data entry form using dmax - doesn't pick up value
Hi all, I'm creating a simple data entry for that is used to add new data to a pre-created table I create the form and set the property to data entry I've added the code for DMAX/I've ...
If you have no records in your table, which you don't, then you'll need to check for null values:
=NZ(DMAX("PupilID","tblPupil"),0)+1
See https://599cd.com/NZ for more help
=NZ(DMAX("PupilID","tblPupil"),0)+1
See https://599cd.com/NZ for more help
- Hi - I do have records - I think this is an issue with my version of access
previously the ID was generated with an expression in the control source - I added it to default value and it works - useful tip above anyway thanks
