I am a beginner and have created a database and one of the functions on my user input form calls for a sequential number to identify the next Job Number [JodID]. The sequential number restart each day. I get the Date to populate the subform with a Date() Query that properly returns only todays jobs. I have added "Me.JobID = DMax("[JobID]", "731DailyReportT", "[Date] = #" & Me.Date & "#") + 1" to the Forms onload event. My exact problem is that unless I manually put a beginning number like 1 in my table, my sequence number is always blank. Any halp would be greatly appreciated since I have been trying to fix this for 3 days.

---

Reply from Richard Rost:

First, I would put this in the BeforeInsert event, not the OnLoad event. This way it only has to run when the use inserts a new record. I would DMAX the current ID, and then if that result is NULL set it to 1. If not, set it to the next number. You'll need a little If/Then statement. Aside from that, your logic is sound.