I have a button if I clik on it, it should change the month to previous month in the text field "dtetxt" the control source of this text field is "Salary Month". With the following code it chages it to 01/11/2022 and save the "Salary Month" as 01/11/2022. Where it should save same as November.
Private Sub Pmonth_Click()
Me.dtetxt = DateAdd("m", -1, [Purchase Date])
End Sub