I am not sure what subforum this belong under, so if I got it wrong, I apologize.
On my form, I have a control displaying an items row number (textbox) and for the life of me, I cant figure out how to make the control use the dmax function (if that even is the correct function to use) so for a given ID, the number will always start at 1 and go up. So for JobID 2, you can have rows 1-5 and for JobID 6, you can have rows 1-50. The rows are not related to each other from JobID to JobID, I would just like a nice numbering system for identification.
On my form, I have a control displaying an items row number (textbox) and for the life of me, I cant figure out how to make the control use the dmax function (if that even is the correct function to use) so for a given ID, the number will always start at 1 and go up. So for JobID 2, you can have rows 1-5 and for JobID 6, you can have rows 1-50. The rows are not related to each other from JobID to JobID, I would just like a nice numbering system for identification.