I have a form (attached) that has a "Yes/No' field on it that needs to be changed based on a Due Date that is based upon a "Paid Date". I use a Button Control that will populate the Due Date based on the number of days after the Paid Date i.e., 1 Quarter, 1/2 Year, or 1 Year (4 Quarters). The due date is based upon how many quarters a member pays for. Members like to pay quarterly, by 1/2 year, or yearly which is ok with our club as some members are snowbirds.
I have coded the Due Date "On Click Event Procedure" thus:
Private Sub Option104_Click() Me!DuesDue = DateAdd("q", 4, Me!DuesPaid)
FirstName.SetFocus
End Sub
What I need to do is change the Current "Yes/No" field to "No" 1 day after the actual Due Date date. I am assuming using a "Date" Function I will be able to accomplish this change.
Any help would be greatly appreciated.
Thank you, thank you, thank you!