Access form: Default value of date, 1 day more than previous records value?

Question

I am trying to set the value of a date field (Date) to one day higher than
the previous records entry. 1/1/2017 next record will auto fill in 1/2/2017

any suggestions would be appreciated

Answer 1

Hi

My idea is to use a query and an Add query.

The first: "FindMaxDateInTable"

SELECT Max(TABLENAME.FIELDNAMEforTheDate) AS MaxDate
FROM TABLENAME;

The Add:"AddMaxDatePlusOne"

INSERT INTO TABLENAME( FIELDNAMEforTheDate )
SELECT [MaxDate]+1 AS OneMoreDay
FROM FindMaxDateInTable;

---

Best // Peter Forss Stockholm GMT +1.00

Answer 2

Thank you so much !! I will try it to see it work for me or not

Answer 3

Hello,

In the form, you could handle AfterInsert event to auto fill the date field.

E.g.

Private Sub Form_AfterInsert()
Me.Field1 = DMax("Field1", "Table1") + 1
End Sub

Regards,

Celeste

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].