I have written a database, but as the data is input the day after the event (on the whole), I am trying to make it so it defaults to the previous working day, all was going well, when I thought I would be really smart and think about Mondays, so I have put in this code, which goes on "NEW RECORD BUTTON". I am not worried about Bank Holidays etc, that can be overtyped, it would be just nice if from Monday to Friday.
Many thanks in advanced, I have trawled the Archives, but to no avail.
DoCmd.GoToRecord , , acNewRec
If Weekday(Date, vbMonday) Then
Me.DateIssued = DateAdd("d", -3, Date)
Me.DateIssued = DateAdd("d", -1, Date)