I would like to have a button that when clicked would move to the last day of the previous month each time. For example, I have an unbound text field with a date of 6-30-2023. When clicked i want it to go to 5-31-23. When clicked again i want to to go to 4-30-23. With the dateadd function it takes it back a month but the dates do not align with the last day of the month, click once it goes to 5-30-23 then to 4-30-23 then 3-30-23 and so on. I tried dateserial and it works on the first click but does not move past that date. I tried me.refresh, me.requery on the text box date field but it did not work. I am now just throwing stuff at it and hoping something works. But unfortunately nothing has so far. I am sure there is an easy fix but i am at a loss.  Any help is appreciated.